Saving all output to "!!{outputDirectory}!!/ppr_pushdown.q.raw". Enter "record" with no arguments to stop it.
>>>  !run !!{qFileDirectory}!!/ppr_pushdown.q
>>>  create table ppr_test (key string) partitioned by (ds string);
No rows affected 
>>>  
>>>  alter table ppr_test add partition (ds = '1234');
No rows affected 
>>>  alter table ppr_test add partition (ds = '1224');
No rows affected 
>>>  alter table ppr_test add partition (ds = '1214');
No rows affected 
>>>  alter table ppr_test add partition (ds = '12+4');
No rows affected 
>>>  alter table ppr_test add partition (ds = '12.4');
No rows affected 
>>>  alter table ppr_test add partition (ds = '12:4');
No rows affected 
>>>  alter table ppr_test add partition (ds = '12%4');
No rows affected 
>>>  alter table ppr_test add partition (ds = '12*4');
No rows affected 
>>>  
>>>  insert overwrite table ppr_test partition(ds = '1234') select * from (select '1234' from src limit 1 union all select 'abcd' from src limit 1) s;
'_c0'
No rows selected 
>>>  insert overwrite table ppr_test partition(ds = '1224') select * from (select '1224' from src limit 1 union all select 'abcd' from src limit 1) s;
'_c0'
No rows selected 
>>>  insert overwrite table ppr_test partition(ds = '1214') select * from (select '1214' from src limit 1 union all select 'abcd' from src limit 1) s;
'_c0'
No rows selected 
>>>  insert overwrite table ppr_test partition(ds = '12+4') select * from (select '12+4' from src limit 1 union all select 'abcd' from src limit 1) s;
'_c0'
No rows selected 
>>>  insert overwrite table ppr_test partition(ds = '12.4') select * from (select '12.4' from src limit 1 union all select 'abcd' from src limit 1) s;
'_c0'
No rows selected 
>>>  insert overwrite table ppr_test partition(ds = '12:4') select * from (select '12:4' from src limit 1 union all select 'abcd' from src limit 1) s;
'_c0'
No rows selected 
>>>  insert overwrite table ppr_test partition(ds = '12%4') select * from (select '12%4' from src limit 1 union all select 'abcd' from src limit 1) s;
'_c0'
No rows selected 
>>>  insert overwrite table ppr_test partition(ds = '12*4') select * from (select '12*4' from src limit 1 union all select 'abcd' from src limit 1) s;
'_c0'
No rows selected 
>>>  
>>>  
>>>  select * from ppr_test where ds = '1234' order by key;
'key','ds'
'1234','1234'
'abcd','1234'
2 rows selected 
>>>  select * from ppr_test where ds = '1224' order by key;
'key','ds'
'1224','1224'
'abcd','1224'
2 rows selected 
>>>  select * from ppr_test where ds = '1214' order by key;
'key','ds'
'1214','1214'
'abcd','1214'
2 rows selected 
>>>  select * from ppr_test where ds = '12.4' order by key;
'key','ds'
'12.4','12.4'
'abcd','12.4'
2 rows selected 
>>>  select * from ppr_test where ds = '12+4' order by key;
'key','ds'
'12+4','12+4'
'abcd','12+4'
2 rows selected 
>>>  select * from ppr_test where ds = '12:4' order by key;
'key','ds'
'12:4','12:4'
'abcd','12:4'
2 rows selected 
>>>  select * from ppr_test where ds = '12%4' order by key;
'key','ds'
'12%4','12%4'
'abcd','12%4'
2 rows selected 
>>>  select * from ppr_test where ds = '12*4' order by key;
'key','ds'
'12*4','12*4'
'abcd','12*4'
2 rows selected 
>>>  select * from ppr_test where ds = '12.*4' order by key;
'key','ds'
No rows selected 
>>>  
>>>  select * from ppr_test where ds = '1234' and key = '1234';
'key','ds'
'1234','1234'
1 row selected 
>>>  select * from ppr_test where ds = '1224' and key = '1224';
'key','ds'
'1224','1224'
1 row selected 
>>>  select * from ppr_test where ds = '1214' and key = '1214';
'key','ds'
'1214','1214'
1 row selected 
>>>  select * from ppr_test where ds = '12.4' and key = '12.4';
'key','ds'
'12.4','12.4'
1 row selected 
>>>  select * from ppr_test where ds = '12+4' and key = '12+4';
'key','ds'
'12+4','12+4'
1 row selected 
>>>  select * from ppr_test where ds = '12:4' and key = '12:4';
'key','ds'
'12:4','12:4'
1 row selected 
>>>  select * from ppr_test where ds = '12%4' and key = '12%4';
'key','ds'
'12%4','12%4'
1 row selected 
>>>  select * from ppr_test where ds = '12*4' and key = '12*4';
'key','ds'
'12*4','12*4'
1 row selected 
>>>  
>>>  
>>>  !record