Grokbase Groups Hive dev June 2011
FAQ
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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupdev @
categorieshive, hadoop
postedJun 14, '11 at 11:03p
activeJun 14, '11 at 11:03p
posts1
users1
websitehive.apache.org

1 user in discussion

Carl Steinbach (JIRA): 1 post

People

Translate

site design / logo © 2022 Grokbase