在搭建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
查看mysql 数据库状态,结果mysql未启动,再启动mysql有报错
Another MySQL daemon already running with the same unix socket。
重启服务器。
然后
cd /var/lib/mysql/
mv mysql.sock mysql.sock.bak
再次重启mysql 启动成功
mysql service start
再次启动hive,启动成功
bin/hive
show databases;