CREATE TABLE TEST1(A INT, B DOUBLE) partitioned by (ds string);
explain extended select max(ds) from TEST1;
select max(ds) from TEST1;

alter table TEST1 add partition (ds='1');
explain extended select max(ds) from TEST1;
select max(ds) from TEST1;

explain extended select count(distinct ds) from TEST1;
select count(distinct ds) from TEST1;

explain extended select count(ds) from TEST1;
select count(ds) from TEST1;

alter table TEST1 add partition (ds='2');
explain extended 
select count(*) from TEST1 a2 join (select max(ds) m from TEST1) b on a2.ds=b.m;
select count(*) from TEST1 a2 join (select max(ds) m from TEST1) b on a2.ds=b.m;


CREATE TABLE TEST2(A INT, B DOUBLE) partitioned by (ds string, hr string);
alter table TEST2 add partition (ds='1', hr='1');
alter table TEST2 add partition (ds='1', hr='2');
alter table TEST2 add partition (ds='1', hr='3');

explain extended select ds, count(distinct hr) from TEST2 group by ds;
select ds, count(distinct hr) from TEST2 group by ds;

explain extended select ds, count(hr) from TEST2 group by ds;
select ds, count(hr) from TEST2 group by ds;

set hive.input.format=org.apache.hadoop.hive.ql.io.CombineHiveInputFormat;

explain extended select max(ds) from TEST1;
select max(ds) from TEST1;

select distinct ds from srcpart;
select min(ds),max(ds) from srcpart;