set hive.lock.numretries=5; set hive.lock.sleep.between.retries=5; DROP TABLE insert_into3_neg; CREATE TABLE insert_into3_neg (key int, value string) PARTITIONED BY (ds string); INSERT INTO TABLE insert_into3_neg PARTITION (ds='1') SELECT * FROM src LIMIT 100; LOCK TABLE insert_into3_neg PARTITION (ds='1') SHARED; INSERT INTO TABLE insert_into3_neg PARTITION (ds='1') SELECT * FROM src LIMIT 100; DROP TABLE insert_into3_neg;