Jesus Camacho Rodriguez created HIVE-24387:
----------------------------------------------
Summary: Metastore access through JDBC handler does not use
correct database accessor
Key: HIVE-24387
URL: https://issues.apache.org/jira/browse/HIVE-24387
Project: Hive
Issue Type: Bug
Components: JDBC storage handler
Reporter: Jesus Camacho Rodriguez
Assignee: Jesus Camacho Rodriguez
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.
{code}
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}
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
