[HIVE-24387] Metastore access through JDBC handler does not use correct database accessor

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: JDBC storage handler
• Labels: pull-request-available
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 13/Nov/20 22:09
• Updated: 27/Feb/24 22:12
• Resolved: 20/Nov/20 05:36

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}

Issue Links

• links to: GitHub Pull Request #1673