Hive出现异常 FAILED: Error In Metadata

刚刚配置hive的元数据库为mysql数据库;
show tables;就出现异常:

FAILED: Error in metadata: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

FAILED: Error in metadata: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClientFAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask


试了很多办法,最后解决了:

重新启动hive

./hive -hiveconf hive.root.logger=DEBUG,console

hive>show table :

出错的最下面有
org.apache.hadoop.hive.metastore.ObjectStore.checkSchema

解决办法:

修改配置文件

第一次运行前先将 hive.metastore.schema.verification 设为false

查看源代码

打印帮助

1

......

2

3	hive.metastore.schema.verification

4

false

5

......

 hive> show tables;
OK
inner_table
Time taken: 12.748 seconds, Fetched: 1 row(s)

问题解决..