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

--! qt:dataset:src
set hive.mapred.mode=nonstrict;
set hive.fetch.task.conversion=more;

create table ppr_test_n0 (key string) partitioned by (ds string);

alter table ppr_test_n0 add partition (ds = '1234');
alter table ppr_test_n0 add partition (ds = '1224');
alter table ppr_test_n0 add partition (ds = '1214');
alter table ppr_test_n0 add partition (ds = '12+4');
alter table ppr_test_n0 add partition (ds = '12.4');
alter table ppr_test_n0 add partition (ds = '12:4');
alter table ppr_test_n0 add partition (ds = '12%4');
alter table ppr_test_n0 add partition (ds = '12*4');

insert overwrite table ppr_test_n0 partition(ds = '1234') select * from (select '1234' from src tablesample (1 rows) union all select 'abcd' from src tablesample (1 rows)) s;
insert overwrite table ppr_test_n0 partition(ds = '1224') select * from (select '1224' from src tablesample (1 rows) union all select 'abcd' from src tablesample (1 rows)) s;
insert overwrite table ppr_test_n0 partition(ds = '1214') select * from (select '1214' from src tablesample (1 rows) union all select 'abcd' from src tablesample (1 rows)) s;
insert overwrite table ppr_test_n0 partition(ds = '12+4') select * from (select '12+4' from src tablesample (1 rows) union all select 'abcd' from src tablesample (1 rows)) s;
insert overwrite table ppr_test_n0 partition(ds = '12.4') select * from (select '12.4' from src tablesample (1 rows) union all select 'abcd' from src tablesample (1 rows)) s;
insert overwrite table ppr_test_n0 partition(ds = '12:4') select * from (select '12:4' from src tablesample (1 rows) union all select 'abcd' from src tablesample (1 rows)) s;
insert overwrite table ppr_test_n0 partition(ds = '12%4') select * from (select '12%4' from src tablesample (1 rows) union all select 'abcd' from src tablesample (1 rows)) s;
insert overwrite table ppr_test_n0 partition(ds = '12*4') select * from (select '12*4' from src tablesample (1 rows) union all select 'abcd' from src tablesample (1 rows)) s;


select * from ppr_test_n0 where ds = '1234' order by key;
select * from ppr_test_n0 where ds = '1224' order by key;
select * from ppr_test_n0 where ds = '1214' order by key;
select * from ppr_test_n0 where ds = '12.4' order by key;
select * from ppr_test_n0 where ds = '12+4' order by key;
select * from ppr_test_n0 where ds = '12:4' order by key;
select * from ppr_test_n0 where ds = '12%4' order by key;
select * from ppr_test_n0 where ds = '12*4' order by key;
select * from ppr_test_n0 where ds = '12.*4' order by key;

select * from ppr_test_n0 where ds = '1234' and key = '1234';
select * from ppr_test_n0 where ds = '1224' and key = '1224';
select * from ppr_test_n0 where ds = '1214' and key = '1214';
select * from ppr_test_n0 where ds = '12.4' and key = '12.4';
select * from ppr_test_n0 where ds = '12+4' and key = '12+4';
select * from ppr_test_n0 where ds = '12:4' and key = '12:4';
select * from ppr_test_n0 where ds = '12%4' and key = '12%4';
select * from ppr_test_n0 where ds = '12*4' and key = '12*4';