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

 

解决方案

# 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;

 

上一篇:Spark系列——从零学习SparkSQL编程(下)


下一篇:【巨杉数据库SequoiaDB】SequoiaDB+SparkSQL 与 SmartBI 整合教程