[ https://issues.apache.org/jira/browse/HIVE-26759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Akshat Mathur updated HIVE-26759: --------------------------------- Affects Version/s: 4.0.0-alpha-2 > ERROR: column "CC_START" does not exist, when Postgres is used as Hive > metastore > -------------------------------------------------------------------------------- > > Key: HIVE-26759 > URL: https://issues.apache.org/jira/browse/HIVE-26759 > Project: Hive > Issue Type: Bug > Affects Versions: 4.0.0-alpha-2 > Reporter: Akshat Mathur > Assignee: Akshat Mathur > Priority: Major > > This error is coming when Postgres is used as Hive Metastore. > Following is the stack trace when HMS service is started: > {code:java} > [Thread-5] ERROR org.apache.hadoop.hive.ql.txn.compactor.Initiator - > Initiator loop caught unexpected exception this time through the loop > org.apache.hadoop.hive.metastore.api.MetaException: Unable to select from > transaction database org.postgresql.util.PSQLException: ERROR: column > "CC_START" does not exist > Position: 1215 > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356) > at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490) > at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408) > at > org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:181) > at > org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:133) > at > com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) > at > com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) > at > org.apache.hadoop.hive.metastore.txn.TxnHandler.showCompact(TxnHandler.java:3894) > at > org.apache.hadoop.hive.ql.txn.compactor.Initiator.run(Initiator.java:154) > at > org.apache.hadoop.hive.metastore.txn.TxnHandler.showCompact(TxnHandler.java:3946) > ~[classes/:?] > at > org.apache.hadoop.hive.ql.txn.compactor.Initiator.run(Initiator.java:154) > ~[hive-exec-4.0.0-SNAPSHOT.jar:4.0.0-SNAPSHOT] {code} > This error disappears when derby is configured as HMS. -- This message was sent by Atlassian Jira (v8.20.10#820010)