
create table ptestfilter (a string) partitioned by (c int);
INSERT OVERWRITE TABLE ptestfilter PARTITION (c) select 'Col1', null;
INSERT OVERWRITE TABLE ptestfilter PARTITION (c) select 'Col2', 5;
show partitions ptestfilter;

select * from ptestfilter;

select * from ptestfilter where c between 2 and 6 ;

drop table ptestfilter;