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 BA041106C4 for ; Tue, 10 Feb 2015 16:58:35 +0000 (UTC) Received: (qmail 49144 invoked by uid 500); 10 Feb 2015 16:58:34 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 49080 invoked by uid 500); 10 Feb 2015 16:58:34 -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 Delivered-To: moderator for dev@hive.apache.org Received: (qmail 95371 invoked by uid 99); 10 Feb 2015 16:45:05 -0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of willddy@gmail.com designates 209.85.223.180 as permitted sender) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=gsswh+Kc5bcvll/tA254qVOIeao544o7NPOi0znOKPk=; b=lCgYrpMVxf1cVbFCMq9hKM5JZ5QbjlPb7XTuxUaQKJMIALPkN2QW0AS/nXS4VOyEOS Okxn4aAAjDXbnlzyXHeSmb4TDtpQgjycAuSocM/ek7pzfSwUr+TNt5y0bifpgQQF4hEh BRSY7sX3pw2aypebtwNCbNGjfTxPtZvK975kynSzI9SaLd4JN+ymOTaIzV0yPG4ZWEhO PDkdVhx/u57LvEnpBlXVieROYtJetnT2OA+n3WRp+2fd/WnQi5sGG056X4osa/nRORvp m+xfZ6A+m0oycwdXu1Kc1m0ft3ug1g1nKv+oLrZRIniKGHauzhFyzCVS2KDCVhrNJGpu sUBQ== MIME-Version: 1.0 X-Received: by 10.50.18.49 with SMTP id t17mr24236806igd.3.1423586674723; Tue, 10 Feb 2015 08:44:34 -0800 (PST) In-Reply-To: References: Date: Tue, 10 Feb 2015 11:44:34 -0500 Message-ID: Subject: Fwd: Hive Index without WITH DEFERRED REBUILD From: DU DU To: dev@hive.apache.org Content-Type: multipart/alternative; boundary=089e0149c0a00dd4fe050ebe9ab8 X-Virus-Checked: Checked by ClamAV on apache.org --089e0149c0a00dd4fe050ebe9ab8 Content-Type: text/plain; charset=UTF-8 Can we create Hive index without specifying "WITH DEFERRED REBUILD"? Right now, it reports following errors. CREATE INDEX table01_index ON TABLE table01 (column2) AS 'COMPACT'; FAILED: Error in metadata: java.lang.RuntimeException: Please specify deferred rebuild using " WITH DEFERRED REBUILD ". FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask According to the design here "WITH DEFERRED REBUILD" is optional. Is this a bug? In addition, I found drop index never check metadata and log here And issues of index in Hive 1.0.0 here Can someone verify this and provide workaround? Thanks, Will --089e0149c0a00dd4fe050ebe9ab8--