ql/src/test/queries/clientpositive/dynamic_partition_skip_default.q

--! qt:dataset:src
SET hive.vectorized.execution.enabled=false;
create table dynamic_part_table(intcol string) partitioned by (partcol1 string, partcol2 string);


insert into table dynamic_part_table partition(partcol1, partcol2) select '1', '1', '1' from src where key=150;

insert into table dynamic_part_table partition(partcol1, partcol2) select '1', NULL, '1' from src where key=150;

insert into table dynamic_part_table partition(partcol1, partcol2) select '1', '1', NULL from src where key=150;

insert into table dynamic_part_table partition(partcol1, partcol2) select '1', NULL, NULL from src where key=150;

explain extended select intcol from dynamic_part_table where partcol1='1' and partcol2='1';

set hive.exec.dynamic.partition.mode=strict;

explain extended select intcol from dynamic_part_table where partcol1='1' and partcol2='1';

explain extended select intcol from dynamic_part_table where (partcol1='1' and partcol2='1')or (partcol1='1' and partcol2='__HIVE_DEFAULT_PARTITION__');