hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Carl Steinbach (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-2220) Better error messages for MetaStore configuration problems
Date Tue, 14 Jun 2011 23:02:47 GMT
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

        

Mime
View raw message