问题描述:
drop table、database 等命令
在hive中执行删表删库操作时,没有反应。过很长时间提示报错
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message: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)
解决办法:
将hive中lib目录下的
mysql-connector-java-5.1.0-bin
jar包更换。