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
