[HIVE-22101] table RUNTIME_STATS Schema Script for Postgres Metastore is wrong

• Type: Bug
• Status: Patch Available
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 3.0.0
• Component/s: Hive
• Labels: pull-request-available
• Assignee: Sam An
• Reporter: Sam An
• Due: 19/Aug/19
• Created: 13/Aug/19 03:26
• Updated: 08/Jun/20 13:28

Description

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.

Issue Links

• links to: GitHub Pull Request #750