hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Shelukhin (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (HIVE-12490) Metastore: Mysql ANSI_QUOTES is not there for some cases
Date Mon, 23 Nov 2015 22:37:10 GMT

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

Sergey Shelukhin edited comment on HIVE-12490 at 11/23/15 10:36 PM:
--------------------------------------------------------------------

Moved it into the higher level method that opens the txn. This path was calling it too late,
after the first query was already issued, this should solve the problem for all the paths.


was (Author: sershe):
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)

Mime
View raw message