You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2019/08/13 18:36:00 UTC
[jira] [Work logged] (HIVE-22101) table RUNTIME_STATS Schema Script
for Postgres Metastore is wrong
[ 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:
users@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)