hive元数据库初始化时报如下错误
org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version.
*** schemaTool failed ***
解决办法
修改mysql的访问权限
mysql> grant all privileges on *.* to 'root'@'xx' identified by 'xx';
mysql> flush privileges;
修改后初始化成功
Metastore connection URL: jdbc:mysql://host:3306/hive?createDatabaseIfNotExist=true
Metastore Connection Driver : com.mysql.jdbc.Driver
Metastore connection User: root
Starting metastore schema initialization to 1.2.0
Initialization script hive-schema-1.2.0.mysql.sql
Initialization script completed
schemaTool completed
