Return-Path: Delivered-To: apmail-hadoop-common-commits-archive@www.apache.org Received: (qmail 9386 invoked from network); 5 May 2010 04:30:21 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 5 May 2010 04:30:21 -0000 Received: (qmail 94020 invoked by uid 500); 5 May 2010 04:30:21 -0000 Delivered-To: apmail-hadoop-common-commits-archive@hadoop.apache.org Received: (qmail 93778 invoked by uid 500); 5 May 2010 04:30:19 -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 93771 invoked by uid 500); 5 May 2010 04:30:18 -0000 Delivered-To: apmail-hadoop-core-commits@hadoop.apache.org Received: (qmail 93768 invoked by uid 99); 5 May 2010 04:30:18 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 May 2010 04:30:18 +0000 X-ASF-Spam-Status: No, hits=-1438.4 required=10.0 tests=ALL_TRUSTED,AWL X-Spam-Check-By: apache.org Received: from [140.211.11.130] (HELO eos.apache.org) (140.211.11.130) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 May 2010 04:30:17 +0000 Received: from eos.apache.org (localhost [127.0.0.1]) by eos.apache.org (Postfix) with ESMTP id E1A0717DB6; Wed, 5 May 2010 04:29:56 +0000 (GMT) MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable From: Apache Wiki To: Apache Wiki Date: Wed, 05 May 2010 04:29:56 -0000 Message-ID: <20100505042956.21646.2655@eos.apache.org> Subject: =?utf-8?q?=5BHadoop_Wiki=5D_Update_of_=22Hive/Locking=22_by_NamitJain?= Dear Wiki user, You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for ch= ange notification. The "Hive/Locking" page has been changed by NamitJain. http://wiki.apache.org/hadoop/Hive/Locking?action=3Ddiff&rev1=3D7&rev2=3D8 -------------------------------------------------- = ||'''Hive Command''' ||'''Locks Acquired''' || ||'''select .. T1 partition P1''' ||'''S on T1, S on T1.P1''' || - ||'''insert into T2(partition P2) select .. T1 partition P1''' ||'''S on = T2, X on T2.P2, S on T1, S on T1.P1''' || + ||'''insert into T2(partition P2) select .. T1 partition P1''' ||'''S on = T2, T1, T1.P1 and X on T2.P2''' || = = In order to avoid deadlocks, a very simple scheme is proposed here. All t= he objects to be locked