hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gopal V (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (HIVE-12490) Metastore: Mysql ANSI_QUOTES is not there for some cases
Date Sat, 21 Nov 2015 12:25:11 GMT

     [ https://issues.apache.org/jira/browse/HIVE-12490?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Gopal V reassigned HIVE-12490:
------------------------------

    Assignee: Gopal V

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

Mime
View raw message