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 25F6410559 for ; Wed, 28 May 2014 02:19:02 +0000 (UTC) Received: (qmail 5686 invoked by uid 500); 28 May 2014 02:19:01 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 5618 invoked by uid 500); 28 May 2014 02:19:01 -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 5609 invoked by uid 500); 28 May 2014 02:19:01 -0000 Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org Received: (qmail 5606 invoked by uid 99); 28 May 2014 02:19:01 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 28 May 2014 02:19:01 +0000 Date: Wed, 28 May 2014 02:19:01 +0000 (UTC) From: "Thejas M Nair (JIRA)" To: hive-dev@hadoop.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (HIVE-7130) schematool is broken for minor version upgrades (eg 0.13.x) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/HIVE-7130?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14010673#comment-14010673 ] Thejas M Nair commented on HIVE-7130: ------------------------------------- {code} [apache-hive-0.13.1-bin18:52]$ bin/schematool -dbType derby -initSchema Picked up JAVA_TOOL_OPTIONS: -Djava.awt.headless=true Picked up JAVA_TOOL_OPTIONS: -Djava.awt.headless=true Metastore connection URL: jdbc:derby:;databaseName=metastore_db;create=true Metastore Connection Driver : org.apache.derby.jdbc.EmbeddedDriver Metastore connection User: APP Starting metastore schema initialization to 0.13.1 org.apache.hadoop.hive.metastore.HiveMetaException: Unknown version specified for initialization: 0.13.1 *** schemaTool failed *** [apache-hive-0.13.1-bin18:35]$ bin/schematool -dbType derby -initSchemaTo 0.12.0 Picked up JAVA_TOOL_OPTIONS: -Djava.awt.headless=true Picked up JAVA_TOOL_OPTIONS: -Djava.awt.headless=true Metastore connection URL: jdbc:derby:;databaseName=metastore_db;create=true Metastore Connection Driver : org.apache.derby.jdbc.EmbeddedDriver Metastore connection User: APP Starting metastore schema initialization to 0.12.0 Initialization script hive-schema-0.12.0.derby.sql Initialization script completed schemaTool completeted [apache-hive-0.13.1-bin18:35]$ bin/schematool -dbType derby -upgradeSchema Picked up JAVA_TOOL_OPTIONS: -Djava.awt.headless=true Picked up JAVA_TOOL_OPTIONS: -Djava.awt.headless=true Metastore connection URL: jdbc:derby:;databaseName=metastore_db;create=true Metastore Connection Driver : org.apache.derby.jdbc.EmbeddedDriver Metastore connection User: APP Starting upgrade metastore schema from version 0.12.0 to 0.13.1 Upgrade script upgrade-0.12.0-to-0.13.0.derby.sql Completed upgrade-0.12.0-to-0.13.0.derby.sql org.apache.hadoop.hive.metastore.HiveMetaException: Found unexpected schema version 0.13.0 *** schemaTool failed *** {code} > schematool is broken for minor version upgrades (eg 0.13.x) > ----------------------------------------------------------- > > Key: HIVE-7130 > URL: https://issues.apache.org/jira/browse/HIVE-7130 > Project: Hive > Issue Type: Bug > Affects Versions: 0.13.1 > Reporter: Thejas M Nair > Assignee: Thejas M Nair > > The schema initialization fails with schema tool in 0.13.1, with the message that "Unknown version specified for initialization: 0.13.1". > The upgrade with schema tool works (ie it runs the upgrade scripts), > but then errors out at the end, when it finds that the version in > metastore is 0.13.0 (not 0.13.1). -- This message was sent by Atlassian JIRA (v6.2#6252)