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