THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
Hive Command | Locks Acquired | ||
select .. T1 partition P1 | S on T1, T1.P1 | ||
insert into T2(partition P2) select .. T1 partition P1 | S on T2, T1, T1.P1 and X on T2.P2 | ||
insert into T2(partition P.Q) select .. T1 partition P1 | S on T2, T2.P, T1, T1.P1 and X on T2.P.Q | ||
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 | ||
| alter table T1 concatenate | X on T1 | ||
alter table T1 | compactX on T1 | alter table T1 add partition P1 | S on T1, X on T1.P1 |
alter table T1 drop partition P1 | S on T1, X on T1.P1 | ||
alter table T1 touch partition P1 | S on T1, X on T1.P1 | ||
alter table T1 set serdeproperties | S on T1 | ||
alter table T1 set serializer | S on T1 | ||
alter table T1 set file format | S on T1 | ||
alter table T1 set tblproperties | X on T1 | ||
| alter table T1 partition P1 concatenate | X on T1.P1 | ||
drop table T1 | X on T1 |
...