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驱动即可