[jira] [Updated] (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 ] ASF GitHub Bot updated HIVE-22101: -- Labels: pull-request-available (was: ) > 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 > > > 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)
[jira] [Updated] (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 updated HIVE-22101: -- Attachment: HIVE-22101.1.patch Status: Patch Available (was: Open) > 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 > Attachments: HIVE-22101.1.patch > > > 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)