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=6&rev2=7 -------------------------------------------------- Based on this, the lock acquired for an operation is as follows: + + ||'''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''' || + + In order to avoid deadlocks, a very simple scheme is proposed here. All the objects to be locked are sorted lexicographically, and the required mode lock is acquired. Note that in some cases, the list of objects may not be known - for eg. in case of dynamic partitions, the list of partitions
