Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-12490

Metastore: Mysql ANSI_QUOTES is not there for some cases

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.0.0
    • 1.3.0, 2.0.0
    • None
    • None

    Description

      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]
      

      Attachments

        1. HIVE-12490.patch
          6 kB
          Sergey Shelukhin
        2. HIVE-12490.WIP.patch
          0.8 kB
          Gopal Vijayaraghavan

        Activity

          People

            sershe Sergey Shelukhin
            gopalv Gopal Vijayaraghavan
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: