Return-Path: X-Original-To: apmail-hive-dev-archive@www.apache.org Delivered-To: apmail-hive-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id DB1DA67EE for ; Tue, 14 Jun 2011 23:03:08 +0000 (UTC) Received: (qmail 27033 invoked by uid 500); 14 Jun 2011 23:03:08 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 27000 invoked by uid 500); 14 Jun 2011 23:03:08 -0000 Mailing-List: contact dev-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list dev@hive.apache.org Received: (qmail 26992 invoked by uid 500); 14 Jun 2011 23:03:08 -0000 Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org Received: (qmail 26989 invoked by uid 99); 14 Jun 2011 23:03:08 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 14 Jun 2011 23:03:08 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED,T_RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.116] (HELO hel.zones.apache.org) (140.211.11.116) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 14 Jun 2011 23:03:07 +0000 Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116]) by hel.zones.apache.org (Postfix) with ESMTP id 5AB034162F0 for ; Tue, 14 Jun 2011 23:02:47 +0000 (UTC) Date: Tue, 14 Jun 2011 23:02:47 +0000 (UTC) From: "Carl Steinbach (JIRA)" To: hive-dev@hadoop.apache.org Message-ID: <790068867.4805.1308092567368.JavaMail.tomcat@hel.zones.apache.org> Subject: [jira] [Created] (HIVE-2220) Better error messages for MetaStore configuration problems MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 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