hive 用mysql做metastore 分区查询报错

select * from part_user where datetime='2015-09';

FAILED: SemanticException 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)

在数据导入分区，在查询时，都不报错，查询时添加分区条件报错 ，

用的是mysql5.6.26 用的jdbc 驱动是mysql-connector-5.1.8.jar 有问题，改成

mysql-connector-java-5.1.36.jar 问题解决