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 C54014DC1 for ; Sun, 12 Jun 2011 04:52:17 +0000 (UTC) Received: (qmail 34211 invoked by uid 500); 12 Jun 2011 04:52:17 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 34136 invoked by uid 500); 12 Jun 2011 04:52:16 -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 33830 invoked by uid 500); 12 Jun 2011 04:52:16 -0000 Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org Received: (qmail 33809 invoked by uid 99); 12 Jun 2011 04:52:16 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 12 Jun 2011 04:52:16 +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; Sun, 12 Jun 2011 04:52:12 +0000 Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116]) by hel.zones.apache.org (Postfix) with ESMTP id 9AAD1414C5E for ; Sun, 12 Jun 2011 04:51:51 +0000 (UTC) Date: Sun, 12 Jun 2011 04:51:51 +0000 (UTC) From: "Esteban Gutierrez (JIRA)" To: hive-dev@hadoop.apache.org Message-ID: <1891792202.366.1307854311630.JavaMail.tomcat@hel.zones.apache.org> In-Reply-To: <791747256.32453.1305937787376.JavaMail.tomcat@hel.zones.apache.org> Subject: [jira] [Updated] (HIVE-2176) Schema creation scripts are incomplete since they leave out tables that are specific to DataNucleus MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/HIVE-2176?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Esteban Gutierrez updated HIVE-2176: ------------------------------------ Attachment: (was: HIVE-2176.2.patch) > Schema creation scripts are incomplete since they leave out tables that are specific to DataNucleus > --------------------------------------------------------------------------------------------------- > > Key: HIVE-2176 > URL: https://issues.apache.org/jira/browse/HIVE-2176 > Project: Hive > Issue Type: Bug > Components: Configuration, Metastore > Affects Versions: 0.5.0, 0.6.0, 0.7.0 > Reporter: Esteban Gutierrez > Assignee: Esteban Gutierrez > Labels: derby, mysql, postgres > Fix For: 0.7.1 > > Attachments: HIVE-2176.3.patch.txt > > > When using the DDL SQL scripts to create the Metastore, tables like SEQUENCE_TABLE are missing and force the user to change the configuration to use Datanucleus to do all the provisioning of the Metastore tables. Adding the missing table definitions to the DDL scripts will allow to have a functional Hive Metastore without enabling additional privileges to the Metastore user and/or enabling datanucleus.autoCreateSchema property in hive-site.xml > [After running the hive-schema-0.7.0.mysql.sql and revoking ALTER and CREATE privileges to the 'metastoreuser'] > hive> show tables; > FAILED: Error in metadata: javax.jdo.JDOException: Exception thrown calling table.exists() for `SEQUENCE_TABLE` > NestedThrowables: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: CREATE command denied to user 'metastoreuser'@'localhost' for table 'SEQUENCE_TABLE' > FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira