[HIVE-12490] Metastore: Mysql ANSI_QUOTES is not there for some cases

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0
• Fix Version/s: 1.3.0, 2.0.0
• Target Version/s: 1.3.0, 2.0.0
• Assignee: Sergey Shelukhin
• Reporter: Gopal Vijayaraghavan
• Created: 21/Nov/15 12:24
• Updated: 16/Feb/16 23:51
• Resolved: 01/Dec/15 02:12

Description

Caused by: 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 '"PART_COL_STATS" where "DB_NAME" = 'tpcds_100' and "TABLE_NAME" =
 'store_sales' at line 1
...
        at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:451) ~[datanucleus-api-jdo-3.2.6.jar:?]
        at org.datanucleus.api.jdo.JDOQuery.executeWithArray(JDOQuery.java:321) ~[datanucleus-api-jdo-3.2.6.jar:?]
        at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.executeWithArray(MetaStoreDirectSql.java:1644) [hive-exec-2.0.0-SNAPSHOT.jar:2.0.0-SNAPSHOT]
        at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.partsFoundForPartitions(MetaStoreDirectSql.java:1227) [hive-exec-2.0.0-SNAPSHOT.jar:2.0.0-SNAPSHOT]
        at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.aggrColStatsForPartitions(MetaStoreDirectSql.java:1157) [hive-exec-2.0.0-SNAPSHOT.jar:2.0.0-SNAPSHOT]
        at org.apache.hadoop.hive.metastore.ObjectStore$9.getSqlResult(ObjectStore.java:6659) [hive-exec-2.0.0-SNAPSHOT.jar:2.0.0-SNAPSHOT]
        at org.apache.hadoop.hive.metastore.ObjectStore$9.getSqlResult(ObjectStore.java:6655) [hive-exec-2.0.0-SNAPSHOT.jar:2.0.0-SNAPSHOT]
        at org.apache.hadoop.hive.metastore.ObjectStore$GetHelper.run(ObjectStore.java:2493) [hive-exec-2.0.0-SNAPSHOT.jar:2.0.0-SNAPSHOT]
        at org.apache.hadoop.hive.metastore.ObjectStore.get_aggr_stats_for(ObjectStore.java:6655) [hive-exec-2.0.0-SNAPSHOT.jar:2.0.0-SNAPSHOT]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_40]