[
https://issues.apache.org/jira/browse/HIVE-22101?focusedWorklogId=294293&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-294293
]
ASF GitHub Bot logged work on HIVE-22101:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 14/Aug/19 00:00
Start Date: 14/Aug/19 00:00
Worklog Time Spent: 10m
Work Description: thejasmn commented on pull request #750: HIVE-22101:
table RUNTIME_STATS Schema Script for Postgres Metastore …
URL: https://github.com/apache/hive/pull/750#discussion_r313659693
##########
File path:
standalone-metastore/metastore-server/src/main/sql/postgres/upgrade-2.3.0-to-3.0.0.postgres.sql
##########
@@ -323,14 +323,14 @@ CREATE TABLE MIN_HISTORY_LEVEL (
CREATE INDEX MIN_HISTORY_LEVEL_IDX ON MIN_HISTORY_LEVEL (MHL_MIN_OPEN_TXNID);
Review comment:
We should also update upgrade-3.1.0-to-3.2.0.postgres.sql
----------------------------------------------------------------
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:
[email protected]
Issue Time Tracking
-------------------
Worklog Id: (was: 294293)
Time Spent: 0.5h (was: 20m)
> 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
(v7.6.14#76016)
