Error in metadata: java.lang.RuntimeException: Unable to instantiate org.apache.

今天配置mysql存储hive的元数据

遇到问题

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

 

 

搜了很久也没解决

后来打开hive -hiveconf hive.root.logger=DEBUG,console 

发现ERROR Datastore.Schema: Failed initialising database. null, message from server: "Host '192.0.0.0' is not allowed to connect to this MySQL server" org.datanucleus.exceptions.NucleusDataStoreException: null, message from server: "Host '192.0.0.0' is not allowed to connect to this MySQL server"

 

在Mysql下设置

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'  IDENTIFIED BY '*' WITH GRANT OPTION;

 

问题解决

 

查看表空间也创建了

mysql> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| hive               |

| mysql              |

| performance_schema |

| test               |

+--------------------+

 

5 rows in set (0.00 sec)