Delete Hive Meta Error

I got this error when I deleted hive table, due to delete hive metastore cascade in mysql:

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 Version: 5.6
  • Hive Version: 2.3.1
  • Mysql Connector Version: 5.1.26

After searching, I found it’s the bug of mysql connector, https://bugs.mysql.com/bug.php?id=66659.

So I change mysql connector to 5.1.39, things done😀