| --! qt:dataset:src |
| set hive.compute.query.using.stats=false; |
| set hive.mapred.mode=nonstrict; |
| DROP TABLE IF EXISTS insert_into6_neg; |
| |
| CREATE TABLE insert_into6_neg (key int, value string) |
| PARTITIONED BY (ds string) TBLPROPERTIES("immutable"="true") ; |
| |
| INSERT INTO TABLE insert_into6_neg PARTITION (ds='1') |
| SELECT * FROM src LIMIT 100; |
| |
| INSERT INTO TABLE insert_into6_neg PARTITION (ds='2') |
| SELECT * FROM src LIMIT 100; |
| |
| SELECT COUNT(*) from insert_into6_neg; |
| |
| INSERT INTO TABLE insert_into6_neg PARTITION (ds='1') |
| SELECT * FROM src LIMIT 100; |
| |
| DROP TABLE insert_into6_neg; |