[
https://issues.apache.org/jira/browse/HIVE-22101?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16917913#comment-16917913
]
Zoltan Haindrich commented on HIVE-22101:
-----------------------------------------
this patch modifies the schema of already released hive versions; which is not
really good - the migration should take care of that....
> 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
> Labels: pull-request-available
> Attachments: HIVE-22101.1.patch
>
> Time Spent: 0.5h
> Remaining Estimate: 0h
>
> 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
(v8.3.2#803003)
