[ 
https://issues.apache.org/jira/browse/HIVE-26390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

francis pang reassigned HIVE-26390:
-----------------------------------


> 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
>            Priority: Major
>
> 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)

Reply via email to