You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Carl Steinbach (JIRA)" <ji...@apache.org> on 2011/06/15 01:02:47 UTC
[jira] [Created] (HIVE-2220) Better error messages for MetaStore
configuration problems
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