Sam An created HIVE-22101:
-----------------------------
Summary: 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
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)
