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 D3C6810673 for ; Tue, 17 Sep 2013 16:03:57 +0000 (UTC) Received: (qmail 99942 invoked by uid 500); 17 Sep 2013 16:03:54 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 99609 invoked by uid 500); 17 Sep 2013 16:03:53 -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 99564 invoked by uid 500); 17 Sep 2013 16:03:52 -0000 Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org Received: (qmail 99540 invoked by uid 99); 17 Sep 2013 16:03:52 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 17 Sep 2013 16:03:52 +0000 Date: Tue, 17 Sep 2013 16:03:52 +0000 (UTC) From: "Prasad Mujumdar (JIRA)" To: hive-dev@hadoop.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (HIVE-3764) Support metastore version consistency check 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-3764?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13769630#comment-13769630 ] Prasad Mujumdar commented on HIVE-3764: --------------------------------------- [~brocknoland] yes, HIVE-3764.1.patch is the latest. The .4.patch left in there was the one that you added (to refresh the correct patch for test run) hence I couldn't remove that. sorry about the confusion. > Support metastore version consistency check > ------------------------------------------- > > Key: HIVE-3764 > URL: https://issues.apache.org/jira/browse/HIVE-3764 > Project: Hive > Issue Type: Improvement > Components: Metastore > Affects Versions: 0.8.0, 0.9.0, 0.10.0, 0.11.0 > Reporter: Prasad Mujumdar > Assignee: Prasad Mujumdar > Fix For: 0.12.0 > > Attachments: HIVE-3764.1.patch, HIVE-3764.4.patch > > > Today there's no version/compatibility information stored in hive metastore. Also the datanucleus configuration property to automatically create missing tables is enabled by default. If you happen to start an older or newer hive or don't run the correct upgrade scripts during migration, the metastore would end up corrupted. The autoCreate schema is not always sufficient to upgrade metastore when migrating to newer release. It's not supported with all databases. Besides the migration often involves altering existing table, changing or moving data etc. > Hence it's very useful to have some consistency check to make sure that hive is using correct metastore and for production systems the schema is not automatically by running hive. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira