mysql impala hive_impala常见错误小结

部署常见问题：

1.mysql jar错误

Caused by: org.datanucleus.exceptions.NucleusException: Attempt to invoke the "DBCP" plugin to create a ConnectionPool gave an error : The specified datastore driver ("com.mysql.jdbc.Driver") was not found in the CLASSPATH. Please check your CLASSPATH specification, and the name of the driver.

拷贝hive的mysql-connector-java.xxxx.jar文件至impala的库文件目录即可默认(/usr/lib/impala/lib)

2.hdfs namenode错误

E0127 19:48:16.708744 31675 impala-server.cc:339] Could not read the HDFS root directory at hdfs://bipcluster. Error was:Operation category READ is not supported in state standby

namenode ha没有自动开启，导致两个namenode都在standby状态。

手动设置为active状态即可。

3.impala特性支持

E0127 19:28:25.289991 13469 impala-server.cc:339] ERROR: short-circuit local reads is disabled because

- Impala cannot read or execute the parent directory ofdfs.domain.socket.path-