在搭建hive本地多用户模式中,启动hive报错
Exception in thread “main” java.lang.RuntimeException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.
再往下还能看到错误信息
java.sql.SQLException: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://localhost/hive_remote?createDatabaseIfNotExist=true, username = hive. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

hive本地多用户模式 启动报错Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient_mysql


hive本地多用户模式 启动报错Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient_java_02

查看mysql 数据库状态,结果mysql未启动,再启动mysql有报错
Another MySQL daemon already running with the same unix socket。
重启服务器。
然后

cd /var/lib/mysql/
 mv mysql.sock mysql.sock.bak

hive本地多用户模式 启动报错Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient_java_03


再次重启mysql 启动成功

mysql service start

hive本地多用户模式 启动报错Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient_mysql_04


再次启动hive,启动成功

bin/hive
 show databases;

hive本地多用户模式 启动报错Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient_mysql_05


阿里云国内75折 回扣 微信号:monov8
阿里云国际,腾讯云国际,低至75折。AWS 93折 免费开户实名账号 代冲值 优惠多多 微信号:monov8 飞机:@monov6
标签: Hadoop