francis pang created HIVE-26390:
-----------------------------------
Summary: TxnHandler.getTxnDbsUpdated() SQL syntax error on
Postgres.
Key: HIVE-26390
URL: https://issues.apache.org/jira/browse/HIVE-26390
Project: Hive
Issue Type: Bug
Components: HiveServer2
Reporter: francis pang
Assignee: francis pang
Need to quote column name for Postgres:
2022-07-09T11:32:14,086 INFO [pool-5-thread-198] txn.TxnHandler: Removed
aborted transactions: ([3543]) from MIN_HISTORY_LEVEL
2022-07-09T11:32:14,086 INFO [pool-5-thread-198] txn.TxnHandler: Non-retryable
error in getTxnDbsUpdated : ERROR: column "t2w_database" does not exist
Position: 17 (SQLState=42703, ErrorCode=0)
2022-07-09T11:32:14,087 ERROR [pool-5-thread-198] metastore.RetryingHMSHandler:
MetaException(message:org.postgresql.util.PSQLException: ERROR: column
"t2w_database" does not exist
Position: 17
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
