You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Akshat Mathur (Jira)" <ji...@apache.org> on 2022/11/18 06:05:00 UTC
[jira] [Updated] (HIVE-26759) ERROR: column "CC_START" does not exist, when Postgres is used as Hive metastore
[ 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)