Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 61EC1708C for ; Sat, 17 Sep 2011 00:50:36 +0000 (UTC) Received: (qmail 22036 invoked by uid 500); 17 Sep 2011 00:50:35 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 21994 invoked by uid 500); 17 Sep 2011 00:50:35 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 21986 invoked by uid 99); 17 Sep 2011 00:50:35 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 17 Sep 2011 00:50:35 +0000 X-ASF-Spam-Status: No, hits=-2.3 required=5.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of kkhambadkone@apple.com designates 17.151.62.51 as permitted sender) Received: from [17.151.62.51] (HELO mail-out.apple.com) (17.151.62.51) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 17 Sep 2011 00:50:24 +0000 MIME-version: 1.0 Content-transfer-encoding: 7BIT Content-type: text/plain; CHARSET=US-ASCII Received: from relay16.apple.com ([17.128.113.55]) by mail-out.apple.com (Oracle Communications Messaging Exchange Server 7u4-20.01 64bit (built Nov 21 2010)) with ESMTP id <0LRN001KK6AA84J1@mail-out.apple.com> for user@hive.apache.org; Fri, 16 Sep 2011 17:50:03 -0700 (PDT) X-AuditID: 11807137-b7bddae0000031a0-f3-4e73f03bcdf3 Received: from fenugreek.apple.com (fenugreek.apple.com [17.128.115.97]) (using TLS with cipher RC4-MD5 (RC4-MD5/128 bits)) (Client did not present a certificate) by relay16.apple.com (Apple SCV relay) with SMTP id 59.70.12704.B30F37E4; Fri, 16 Sep 2011 17:56:27 -0700 (PDT) Received: from [17.153.28.180] by fenugreek.apple.com (Oracle Communications Messaging Exchange Server 7u4-20.01 64bit (built Nov 21 2010)) with ESMTPSA id <0LRN00MK56BF3X40@fenugreek.apple.com> for user@hive.apache.org; Fri, 16 Sep 2011 17:50:03 -0700 (PDT) From: Krish Khambadkone Subject: Required table missing : "`CDS`" in Catalog Date: Fri, 16 Sep 2011 17:50:02 -0700 Message-id: <358996AD-ED2A-46EC-B52F-9D3BD775EAA8@apple.com> To: user@hive.apache.org X-Mailer: Apple Mail (2.1084) X-Brightmail-Tracker: H4sIAAAAAAAAA+NgFvrHJMWRmVeSWpSXmKPExsUi2FCcqGv9odjPYPZEE4vW3mdsDowe038v YgxgjOKySUnNySxLLdK3S+DK+L7rG2vBE/GKBz1/WBsY94h0MXJySAiYSPxr3MoOYYtJXLi3 nq2LkYtDSGAGk0TTpZdsIAleAUGJH5PvsXQxcnAwC8hLHDwvCxJmFtCS+P6olQWivoNJ4tK2 DcwgCTYBA4muLd1g9cJACyY3mIOEWQRUJRavPckKEuYVsJFYvNcfJCwiICFx8MgRRpCwhICs RNOyjAmMvLOQ7J2FsHcWkr0LGJlXMQoWpeYkVhqa6SUWFOSk6iXn525iBIdKofkOxu1/5Q4x CnAwKvHwfuws9hNiTSwrrsw9xCjBwawkwmtgDxTiTUmsrEotyo8vKs1JLT7EKM3BoiTOa1NY 5CckkJ5YkpqdmlqQWgSTZeLglGpgLFry5U7G4S6Pvsga2wJGxZ0bXc6d843fI2I44+ltnwnt JXOlxD/KetQEOBp29S8UfpP660torr92a9Uss4JfU465+JzvcXN0ik+/M//JnWatt9Hu7WHN b6Qd/v5/yBYXEMOubfez7N7V3T/1PZ4sXbhrWtP2E+vLW4OT/4qdjojca3luXucqJZbijERD Leai4kQA5YZjARECAAA= X-Virus-Checked: Checked by ClamAV on apache.org I have checked out the latest HIVE Trunk and built it. I am now trying to configure a mysql metastore. I ran the script hive-schema-0.7.0.mysql.sql which was the latest one in the list after creating the metastore database. So why is it complaining about this CDS table? 2011-09-16 17:45:25,132 ERROR exec.Task (SessionState.java:printError(365)) - FAILED: Error in metadata: MetaException(message:Got exception: javax.jdo.JDODataStoreException Required table missing : "`CDS`" in Catalog "" Schema "". DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable "datan ucleus.autoCreateTables") org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:Got exception: javax.jdo.JDODataStoreException Req uired table missing : "`CDS`" in Catalog "" Schema "". DataNucleus requires this table to perform its persistence operatio ns. Either your MetaData is incorrect, or you need to enable "datanucleus.autoCreateTables") at org.apache.hadoop.hive.ql.metadata.Hive.getTablesByPattern(Hive.java:936) at org.apache.hadoop.hive.ql.metadata.Hive.getAllTables(Hive.java:908) at org.apache.hadoop.hive.ql.exec.DDLTask.showTables(DDLTask.java:1834) at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:299) at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:132) at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57) at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1346) at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1137) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:946) at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:253) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:210) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:401) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:664) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.hadoop.util.RunJar.main(RunJar.java:186) Caused by: MetaException(message:Got exception: javax.jdo.JDODataStoreException Required table missing : "`CDS`" in Catalo g "" Schema "". DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable "datanucleus.autoCreateTables") at org.apache.hadoop.hive.metastore.MetaStoreUtils.logAndThrowMetaException(MetaStoreUtils.java:779) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTables(HiveMetaStoreClient.java:736) at org.apache.hadoop.hive.ql.metadata.Hive.getTablesByPattern(Hive.java:934) ... 17 more