[ https://issues.apache.org/jira/browse/HIVE-22101?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16905866#comment-16905866 ]
Hive QA commented on HIVE-22101: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12977435/HIVE-22101.1.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:green}SUCCESS:{color} +1 due to 16734 tests passed Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/18320/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/18320/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-18320/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase {noformat} This message is automatically generated. ATTACHMENT ID: 12977435 - PreCommit-HIVE-Build > 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)