[ https://issues.apache.org/jira/browse/HIVE-22101?focusedWorklogId=294088&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-294088 ]
ASF GitHub Bot logged work on HIVE-22101: ----------------------------------------- Author: ASF GitHub Bot Created on: 13/Aug/19 18:35 Start Date: 13/Aug/19 18:35 Worklog Time Spent: 10m Work Description: sam-an-cloudera commented on pull request #750: HIVE-22101: table RUNTIME_STATS Schema Script for Postgres Metastore … URL: https://github.com/apache/hive/pull/750 …is wrong (Sam An via Naveen Gangam) In Postgres SQL script, identifiers such as table, index, and column names need to be quoted to stay in CAPS. This PR fixes for table RUNTIME_STATS. ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org Issue Time Tracking ------------------- Worklog Id: (was: 294088) Time Spent: 10m Remaining Estimate: 0h > 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: 10m > 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 (v7.6.14#76016)