You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Sam An (JIRA)" <ji...@apache.org> on 2019/08/13 03:27:00 UTC
[jira] [Assigned] (HIVE-22101) table RUNTIME_STATS Schema Script
for Postgres Metastore is wrong
[ https://issues.apache.org/jira/browse/HIVE-22101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sam An reassigned HIVE-22101:
-----------------------------
> table RUNTIME_STATS Schema Script for Postgres Metastore is wrong
> -----------------------------------------------------------------
>
> Key: HIVE-22101
> URL: https://issues.apache.org/jira/browse/HIVE-22101
> Project: Hive
> Issue Type: Bug
> Components: Hive
> Affects Versions: 3.0.0
> Reporter: Sam An
> Assignee: Sam An
> Priority: Minor
>
> In some test clusters, we found the following backtrace for Postgres backed metastore.
> 2019-07-19 14:15:43,847 WARN DataNucleus.Query: [pool-5-thread-2]: Query for candidates of org.apache.hadoop.hive.metastore.model.MRuntimeStat and subclasses resulted in no possible candidates
> org.datanucleus.store.rdbms.exceptions.MissingTableException: Required table missing : ""RUNTIME_STATS"" in Catalog "" Schema "". DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable "datanucleus.schema.autoCreateTables"
> at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:606) ~[datanucleus-rdbms-4.1.19.jar:?]
> at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:3385) ~[datanucleus-rdbms-4.1.19.jar:?]
> at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2896) ~[datanucleus-rdbms-4.1.19.jar:?]
> at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:119) ~[datanucleus-rdbms-4.1.19.jar:?]
> The root cause of this is RUNTIME_STATS table is created without quotes, resulting in lower case table. When it's queried, the table cannot be found.
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)