Better error messages for MetaStore configuration problems
----------------------------------------------------------
Key: HIVE-2220
URL: https://issues.apache.org/jira/browse/HIVE-2220
Project: Hive
Issue Type: Improvement
Components: Diagnosability, Metastore
Reporter: Carl Steinbach
Assignee: Carl Steinbach
We need to improve the error messages seen by users when the metastore is not
configured correctly.
MySQL JDBC JAR not on classpath:
{noformat}
hive> show tables;
show tables;
FAILED: Error in metadata: javax.jdo.JDOFatalInternalException: Error creating
transactional connection factory
NestedThrowables:
java.lang.reflect.InvocationTargetException
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
{noformat}
JDBC URL references a MySQL DB that doesn't exist:
{noformat}
hive> show tables;
FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: Unknown
database 'mdb'
NestedThrowables:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown database 'mdb'
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
{noformat}
datanucleus.autoCreateSchema=false and metastore schema doesn't exist:
{noformat}
hive> show tables;
FAILED: Error in metadata: javax.jdo.JDODataStoreException: 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.autoCreateTables"
NestedThrowables:
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.autoCreateTables"
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
{noformat}
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
