[jira] [Commented] (HIVE-26048) Missing quotation mark in findReadyToClean query

["Antal Sinkovits (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-26048?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17509814#comment-17509814 ] 

Antal Sinkovits commented on HIVE-26048:
----------------------------------------

Pushed to master. Thanks for the. review [~klcopp] and [~dkuzmenko].

> Missing quotation mark in findReadyToClean query
> ------------------------------------------------
>
>                 Key: HIVE-26048
>                 URL: https://issues.apache.org/jira/browse/HIVE-26048
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 4.0.0-alpha-1
>            Reporter: Antal Sinkovits
>            Assignee: Antal Sinkovits
>            Priority: Major
>              Labels: ACID, pull-request-available
>             Fix For: 4.0.0-alpha-1
>
>          Time Spent: 0.5h
>  Remaining Estimate: 0h
>
> 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)