hive 启动 或者做增删该查时,如果报错
FAILED: SemanticException org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
是因为mysql没有启动权限
先查看vi /etc/hosts
[root@sure hadoop]# vi /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.236.128 sure
再查看hostname:
[root@sure hadoop]# hostname
sure
都正确。
尝试启动mysql
[root@sure hadoop]# mysql -u root -p
Enter password: 输入密码 进入后
mysql> GRANT ALL PRIVILEGES ON *.* TO 'hadoop'@'sure' IDENTIFIED BY 'hadoop' WITH GRANT OPTION;
Query OK, 0 rows affected (0.25 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.08 sec)
再次使用hive即可。