hive删除表报错

metastore.RetryingHMSHandler: HMSHandler Fatal error: 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

 

 

解决办法:

是mysql的版本和驱动的版本不匹配导致的,但是mysql5.6已经抛弃了这个参数,所以会报上面错误,

改用最新的mysql驱动即可

 

posted @ 2017-11-30 17:54  0xcafedaddy  阅读(734)  评论(0编辑  收藏  举报