今天配置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)