[ 
https://issues.apache.org/jira/browse/HIVE-12490?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15032464#comment-15032464
 ] 

Sergey Shelukhin commented on HIVE-12490:
-----------------------------------------

These tests were broken on other JIRAs too at the time

> 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)

Reply via email to