hadoop-common-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Hadoop Wiki] Update of "Hive/Locking" by NamitJain
Date Wed, 05 May 2010 04:35:26 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.

The "Hive/Locking" page has been changed by NamitJain.
http://wiki.apache.org/hadoop/Hive/Locking?action=diff&rev1=8&rev2=9

--------------------------------------------------

  ||'''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, T1, T1.P1 and
X on T2.P2''' ||
+ ||'''alter table T1 rename T2'''||'''X on T1'''||
+ ||'''alter table T1 add cols'''||'''X on T1'''||
+ ||'''alter table T1 replace cols'''||'''X on T1'''||
+ ||'''alter table T1 change cols'''||'''X on T1'''||
+ 
  
  
  In order to avoid deadlocks, a very simple scheme is proposed here. All	the objects to be
locked

Mime
View raw message