FAILED: SemanticException org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeExcepti

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

进入以下目录

cd $HIVE_HOME/scripts/metastore/upgrade/mysql/
ll

显示:

-rw-r--r-- 1 user user 12322 8月  13  2019 hive-schema-0.4.0.mysql.sql
-rw-r--r-- 1 user user 12322 8月  13  2019 hive-schema-0.4.1.mysql.sql
-rw-r--r-- 1 user user 13565 8月  13  2019 hive-schema-0.5.0.mysql.sql
-rw-r--r-- 1 user user 13798 8月  13  2019 hive-schema-0.6.0.mysql.sql
-rw-r--r-- 1 user user 24716 8月  13  2019 hive-schema-0.7.0.mysql.sql
-rw-r--r-- 1 user user 25914 8月  13  2019 hive-schema-0.8.0.mysql.sql
-rw-r--r-- 1 user user 25914 8月  13  2019 hive-schema-0.9.0.mysql.sql
-rw-r--r-- 1 user user 35192 8月  13  2019 hive-schema-1.1.0.mysql.sql
-rw-r--r-- 1 user user 35192 8月  13  2019 hive-schema-1.2.0.mysql.sql
-rw-r--r-- 1 user user 34845 8月  13  2019 hive-schema-1.3.0.mysql.sql
-rw-r--r-- 1 user user 34845 8月  13  2019 hive-schema-2.0.0.mysql.sql
-rw-r--r-- 1 user user 35488 8月  13  2019 hive-schema-2.1.0.mysql.sql
-rw-r--r-- 1 user user 35543 8月  13  2019 hive-schema-2.2.0.mysql.sql
-rw-r--r-- 1 user user 35543 8月  13  2019 hive-schema-2.3.0.mysql.sql

< Login into MySQL > mysql -uuser -p

mysql> drop database IF EXISTS hive;
mysql> create database hive;
mysql> use hive;
mysql> source hive-schema-2.3.0.mysql.sql;

Restart Hive metastore.

nohup hive --service metastore  2>&1 &