异常结果:
hive> show databases;
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
方案一:
-
解决
尝试修改了一下MySQL的日志格式:
mysq -u root -p
mysql> set global binlog_format='MIXED';
再试,Ok了。 记得必须是root用户才有权限更改的。
将hive.site.xml文件中的
<property>
<name>hive.metastore.schema.verification</name>
<value>true</value>
<description>
</description>
</property>
改为false
方案三:
由于授权失败的需要对其重新授权
mqsql -uroot
mysql>grant all on *.* to hadoop@'master' identified by 'hadoop';
mysql>grant all on *.* to hadoop@'localhost' identified by 'hadoop';
mysql>grant all on *.* to hadoop@'%' identified by 'hadoop';
mysql> flush privileges;