hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sam An (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (HIVE-22101) table RUNTIME_STATS Schema Script for Postgres Metastore is wrong
Date Tue, 13 Aug 2019 03:27:00 GMT

     [ https://issues.apache.org/jira/browse/HIVE-22101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Sam An reassigned HIVE-22101:
-----------------------------


> 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
>
> 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)

Mime
View raw message