org datanucleus store rdbms exceptions MissingTableException Required table missing DBS in Catalog Schema

Question

Hi everyone,

I am getting an error in hive metastore_db. But I am able to solve this.

WARN Query: Query for candidates of org.apache.hadoop.hive.metastore.model.MDatabase and subclasses resulted in no possible candidates

Required table missing: "DBS" 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"

org.datanucleus.store.rdbms.exceptions.MissingTableException: Required table missing : "DBS" 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)

   at

org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:33
85)

Thank You

Answer 1

Hi@akhtar,

Here you have to add the below  properties in hive-site.xml file. I think hive server is not able to get the metastore warehouse directory.

<property>
<value>hive.metastore.local</value>
<name>true</name>
</property>
<property>
<name>hive.metastore.warehouse.dir</name>
<value>hdfs://path</value>
</property>

Add these properties and try again, hope it will work.

Thank You