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 ~]#

正常截图