You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "francis pang (Jira)" <ji...@apache.org> on 2022/07/13 18:30:00 UTC
[jira] [Updated] (HIVE-26390) TxnHandler.getTxnDbsUpdated() SQL syntax error on Postgres.
[ https://issues.apache.org/jira/browse/HIVE-26390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
francis pang updated HIVE-26390:
--------------------------------
Description:
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)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:329)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:315)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:291)
at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:243)
at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:108)
at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
at org.apache.hadoop.hive.metastore.txn.TxnHandler.getTxnDbsUpdated(TxnHandler.java:1347)
was:
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)
> 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)
> at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408)
> at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:329)
> at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:315)
> at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:291)
> at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:243)
> at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:108)
> at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
> at org.apache.hadoop.hive.metastore.txn.TxnHandler.getTxnDbsUpdated(TxnHandler.java:1347)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)