Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Cloudera Manager CDH (5.10.0) Hive installation issues

Cloudera Manager CDH (5.10.0) Hive installation issues

New Contributor

Having issues while configuring/statrting Hive using manger, Are there any bugs reported for Hive during install?

Here is what I get from the log file..

2017-03-15 17:31:26,101 WARN org.apache.hadoop.hive.metastore.MetaStoreDirectSql: [main]: Self-test query [select "DB_ID" from "DBS"] failed; direct SQL is disabled
javax.jdo.JDODataStoreException: Error executing SQL query "select "DB_ID" from "DBS"".

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'scm.DBS' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) 

Required table missing : "`VERSION`" in Catalog "" Schema "". DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable "datanucleus.autoCreateTables"
org.datanucleus.store.rdbms.exceptions.MissingTableException: Required table missing : "`VERSION`" in Catalog "" Schema "". DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable "datanucleus.autoCreateTables"
at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:485)

2017-03-15 17:31:38,830 ERROR org.apache.hadoop.hive.metastore.HiveMetaStore: [main]: Metastore Thrift Server threw an exception...
MetaException(message:Version information not found in metastore. )

2017-03-15 17:31:38,839 INFO org.apache.hadoop.hive.metastore.HiveMetaStore: [Thread-3]: Shutting down hive metastore.

 

Thanks

SB

1 REPLY 1
Highlighted

Re: Cloudera Manager CDH (5.10.0) Hive installation issues

Guru

Hi,

 

This looks like that you have not created MetaStore Database for Hive to use, as we can see that the error was "Table 'scm.DBS' doesn't exist".

 

As you are using Cloudera Manager, I suggest that you go to CM > Hive > Actions > "Create Hive MetaStore Database Tables", then follow on screen instructions. You will have to make sure that Hive is stopped before you can run this, otherwise it will be greyed out.

 

Once this is done, try to restart Hive again.

 

Hope this helps.