create table dynamic_part_table(intcol string) partitioned by (partcol1 string, partcol2 string);

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

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__');