问题一 (Hive元数据库编码异常)
问题描述:
解决方案:
##设置hive数据库编码为latin1
mysql > alter database hive character set latin1;
问题二 (JDBC版本异常)
问题描述:
解决方案:
JDBC Driver版本过低引起的异常,使用高版本的JDBC驱动
问题三 (Mysql数据库异常)
问题描述:
Starting Hive Metastore Server javax.jdo.JDOFatalDataStoreException: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://192.168.52.130:3306/hive_remote?createDatabaseIfNotExist=true, username = root. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: —— java.sql.SQLException: null, message from server: “Host ‘192.168.52.128’ is not allowed to connect to this MySQL server”
解决方案:
①、将root用户添加到mysql组
[root@hadoop07 ~]# useradd -g root mysql
②、修改root用户的密码