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 了一下，關(guān)于這方面的錯誤都是spring的碧囊，看了幾個以后有人說是驅(qū)動版本跟MySQL的版本差太大树灶，于是抱著試試的態(tài)度把驅(qū)動版本提高了一下，
果然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 ~]#
正常截圖
