hive 安装运行异常及解决方法

hive 安装运行错误及解决办法

1.hive> show tables;
FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: Communications link failure

Last packet sent to the server was 0 ms ago.
NestedThrowables:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

解决办法：将hive-site.xml中链接数据库的ip地址换成域名，例如localhost 即可。