Return-Path: Delivered-To: apmail-hadoop-common-commits-archive@www.apache.org Received: (qmail 39429 invoked from network); 2 Feb 2011 00:57:00 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 2 Feb 2011 00:57:00 -0000 Received: (qmail 29536 invoked by uid 500); 2 Feb 2011 00:57:00 -0000 Delivered-To: apmail-hadoop-common-commits-archive@hadoop.apache.org Received: (qmail 29474 invoked by uid 500); 2 Feb 2011 00:56:59 -0000 Mailing-List: contact common-commits-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: common-dev@hadoop.apache.org Delivered-To: mailing list common-commits@hadoop.apache.org Received: (qmail 29467 invoked by uid 500); 2 Feb 2011 00:56:59 -0000 Delivered-To: apmail-hadoop-core-commits@hadoop.apache.org Received: (qmail 29464 invoked by uid 99); 2 Feb 2011 00:56:59 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Feb 2011 00:56:59 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.131] (HELO eos.apache.org) (140.211.11.131) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Feb 2011 00:56:58 +0000 Received: from eosnew.apache.org (localhost [127.0.0.1]) by eos.apache.org (Postfix) with ESMTP id B84A15F0; Wed, 2 Feb 2011 00:56:29 +0000 (UTC) MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable From: Apache Wiki To: Apache Wiki Date: Wed, 02 Feb 2011 00:56:29 -0000 Message-ID: <20110202005629.39871.10648@eosnew.apache.org> Subject: =?utf-8?q?=5BHadoop_Wiki=5D_Update_of_=22Hive/PartitionedViews=22_by_John?= =?utf-8?q?Sichi?= X-Virus-Checked: Checked by ClamAV on apache.org Dear Wiki user, You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for ch= ange notification. The "Hive/PartitionedViews" page has been changed by JohnSichi. http://wiki.apache.org/hadoop/Hive/PartitionedViews?action=3Ddiff&rev1=3D6&= rev2=3D7 -------------------------------------------------- = Likewise, suppose you have view V2 which selects from T1 (with no WHERE c= lause) and is partitioned on C2. Then a query such as SELECT * FROM V2 WHE= RE C2=3D3 will fail; even though the view partition column is constrained, = there is no predicate on the underlying T1's partition column C1. = + =3D View Definition Changes =3D + = + Currently, changing a view definition requires dropping the view and recr= eating it. This implies dropping and recreating all existing partitions as= well, which could be very expensive. + = + This implies that followup support for [[https://issues.apache.org/jira/b= rowse/HIVE-1078|CREATE OR REPLACE]] is very important, and that it needs to= preserve existing partitions (after validating that they are still compati= ble with the new view definition). +=20