cdh hive mysql驱动_CDH添加hive组件，异常解决

CDH添加hive组件，异常解决

CM界面异常

异常截图

hive角色日志

[pool-5-thread-26]:

javax.jdo.JDODataStoreException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1

at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:451)

at org.datanucleus.api.jdo.JDOQuery.execute(JDOQuery.java:252)

at org.apache.hadoop.hive.metastore.ObjectStore.getMDatabase(ObjectStore.java:597)

at org.apache.hadoop.hive.metastore.ObjectStore.getJDODatabase(ObjectStore.java:653

解决办法：

google 了一下，关于这方面的错误都是spring的，看了几个以后有人说是驱动版本跟MySQL的版本差太大，于是抱着试试的态度把驱动版本提高了一下，

果然ok，

[root@hadoop2 ~]# mv /opt/cloudera/parcels/CDH/lib/hive/lib/mysql-connector-java-5.1.7-bin.jar /opt/cloudera/parcels/CDH/lib/hive/lib/mysql-connector-java-5.1.7-bin.jar.bak

[root@hadoop2 ~]# cp mysql-connector-java-5.1.37.jar /opt/cloudera/parcels/CDH/lib/hive/lib

[root@hadoop2 ~]#

正常截图