Antal Sinkovits created HIVE-26048:
--------------------------------------
Summary: Missing quotation mark in findReadyToClean query
Key: HIVE-26048
URL: https://issues.apache.org/jira/browse/HIVE-26048
Project: Hive
Issue Type: Bug
Reporter: Antal Sinkovits
Assignee: Antal Sinkovits
Missing quotation mark causes postgres column error
{code}
2022-03-18T00:53:43,314 ERROR [Thread-651] compactor.Cleaner: Caught an
exception in the main loop of compactor cleaner, MetaException(message:Unable
to connect to transaction database org.postgresql.util.PSQLException: ERROR:
column "cq_retry_retention" does not exist
Position: 485
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
at
org.apache.hive.com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:108)
at
org.apache.hive.com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
at
org.apache.hadoop.hive.metastore.txn.CompactionTxnHandler.findReadyToClean(CompactionTxnHandler.java:374)
at org.apache.hadoop.hive.ql.txn.compactor.Cleaner.run(Cleaner.java:146)
)
at
org.apache.hadoop.hive.metastore.txn.CompactionTxnHandler.findReadyToClean(CompactionTxnHandler.java:397)
at org.apache.hadoop.hive.ql.txn.compactor.Cleaner.run(Cleaner.java:146)
{code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
