[
https://issues.apache.org/jira/browse/HIVE-12490?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergey Shelukhin updated HIVE-12490:
------------------------------------
Attachment: HIVE-12490.patch
Just moved it into the higher level method that opens the txn. This path was
calling it too later, after the first query was already issued, this should
solve the problem for all the paths.
> 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
> Affects Versions: 2.0.0
> Reporter: Gopal V
> Assignee: Sergey Shelukhin
> Attachments: HIVE-12490.WIP.patch, HIVE-12490.patch
>
>
> {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)
