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

Metastore access through JDBC handler does not use correct database accessor

    XMLWordPrintableJSON

    Details

      Description

      There is some differences in the SQL syntax for each RDBMS generated by the database accessor. For metastore, we always end up with the default accessor, which lead to errors, e.g., when a limit query is executed for a Postgres-backed metastore.

      Error: java.io.IOException: java.io.IOException: org.apache.hive.storage.jdbc.exception.HiveJdbcDatabaseAccessException: Error while trying to get column names: ERROR: syntax error at or near "{"
      Position: 200 (state=,code=0)
      
      SELECT "TBL_COLUMN_GRANT_ID", "COLUMN_NAME", "CREATE_TIME", "GRANT_OPTION", "GRANTOR", "GRANTOR_TYPE", "PRINCIPAL_NAME", "PRINCIPAL_TYPE", "TBL_COL_PRIV", "TBL_ID", "AUTHORIZER" FROM "TBL_COL_PRIVS"
      {LIMIT 1}
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                jcamachorodriguez Jesus Camacho Rodriguez
                Reporter:
                jcamachorodriguez Jesus Camacho Rodriguez
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 20m
                  20m