常见错误 - sparkSql和hive的整合之mysql报错

# hive

# show databases;

hive> show databases;
FAILED: SemanticException org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient

 

查看log日志：

hive.log 文件

 

mysql -u root -p 

# input your password

# use hive的元数据库

解决方案

# SELECT 'Upgrading MetaStore schema from 2.2.0 to 2.3.0' AS MESSAGE;

#UPDATE VERSION SET SCHEMA_VERSION='2.3.0', VERSION_COMMENT='Hive release version 2.3.0' where VER_ID=1;
#SELECT 'Finished upgrading MetaStore schema from 2.2.0 to 2.3.0' AS MESSAGE;