| set hive.vectorized.execution.enabled=false; | |
| SET hive.optimize.index.filter=true; | |
| SET hive.optimize.ppd=true; | |
| -- Test predicate with partitioned columns | |
| CREATE TABLE part1_n1 (id int, content string) PARTITIONED BY (p string) STORED AS PARQUET; | |
| ALTER TABLE part1_n1 ADD PARTITION (p='p1'); | |
| INSERT INTO TABLE part1_n1 PARTITION (p='p1') VALUES (1, 'a'), (2, 'b'); | |
| SELECT * FROM part1_n1 WHERE p='p1'; | |
| DROP TABLE part1_n1 PURGE; |