Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id AE3E5200BAC for ; Wed, 26 Oct 2016 20:44:00 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id ACE7E160AE1; Wed, 26 Oct 2016 18:44:00 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id EA221160B04 for ; Wed, 26 Oct 2016 20:43:59 +0200 (CEST) Received: (qmail 82998 invoked by uid 500); 26 Oct 2016 18:43:58 -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 82920 invoked by uid 99); 26 Oct 2016 18:43:58 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 26 Oct 2016 18:43:58 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id 976392C0086 for ; Wed, 26 Oct 2016 18:43:58 +0000 (UTC) Date: Wed, 26 Oct 2016 18:43:58 +0000 (UTC) From: "Yongzhi Chen (JIRA)" To: dev@hive.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (HIVE-15072) Schematool should recognize missing tables in metastore MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Wed, 26 Oct 2016 18:44:00 -0000 Yongzhi Chen created HIVE-15072: ----------------------------------- Summary: Schematool should recognize missing tables in metastore Key: HIVE-15072 URL: https://issues.apache.org/jira/browse/HIVE-15072 Project: Hive Issue Type: Improvement Components: Metastore Reporter: Yongzhi Chen When Install a new database failed half way(for some other reasons), not all of the metastore tables are installed. This caused HMS server failed to start up due to missing tables. Re-run the Schematool, It ran successfully, and in the stdout log said: "Database already has tables. Skipping table creation". However, restarting HMS getting the same error reporting missing tables. Schematool should detect missing tables and provide options to go ahead and recreate missing tables in the case of new installation -- This message was sent by Atlassian JIRA (v6.3.4#6332)