Gopal V created HIVE-12490:
------------------------------
Summary: Metastore: Mysql ANSI_QUOTES is not there for some cases
Key: HIVE-12490
URL: https://issues.apache.org/jira/browse/HIVE-12490
Project: Hive
Issue Type: Bug
Reporter: Gopal V
{code}
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]
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
