Saving all output to "!!{outputDirectory}!!/ppr_pushdown2.q.raw". Enter "record" with no arguments to stop it.
>>>  !run !!{qFileDirectory}!!/ppr_pushdown2.q
>>>  create table ppr_test (key string) partitioned by (ds string);
No rows affected 
>>>  
>>>  insert overwrite table ppr_test partition(ds='2') select '2' from src limit 1;
'_c0'
No rows selected 
>>>  insert overwrite table ppr_test partition(ds='22') select '22' from src limit 1;
'_c0'
No rows selected 
>>>  
>>>  select * from ppr_test where ds = '2';
'key','ds'
'2','2'
1 row selected 
>>>  select * from ppr_test where ds = '22';
'key','ds'
'22','22'
1 row selected 
>>>  
>>>  
>>>  create table ppr_test2 (key string) partitioned by (ds string, s string);
No rows affected 
>>>  insert overwrite table ppr_test2 partition(ds='1', s='2') select '1' from src limit 1;
'_c0'
No rows selected 
>>>  insert overwrite table ppr_test2 partition(ds='2', s='1') select '2' from src limit 1;
'_c0'
No rows selected 
>>>  
>>>  select * from ppr_test2 where s = '1';
'key','ds','s'
'2','2','1'
1 row selected 
>>>  select * from ppr_test2 where ds = '1';
'key','ds','s'
'1','1','2'
1 row selected 
>>>  
>>>  
>>>  create table ppr_test3 (key string) partitioned by (col string, ol string, l string);
No rows affected 
>>>  insert overwrite table ppr_test3 partition(col='1', ol='2', l = '3') select '1' from src limit 1;
'_c0'
No rows selected 
>>>  insert overwrite table ppr_test3 partition(col='1', ol='1', l = '2') select '2' from src limit 1;
'_c0'
No rows selected 
>>>  insert overwrite table ppr_test3 partition(col='1', ol='2', l = '1') select '3' from src limit 1;
'_c0'
No rows selected 
>>>  
>>>  select * from ppr_test3 where l = '1';
'key','col','ol','l'
'3','1','2','1'
1 row selected 
>>>  select * from ppr_test3 where l = '2';
'key','col','ol','l'
'2','1','1','2'
1 row selected 
>>>  select * from ppr_test3 where ol = '1';
'key','col','ol','l'
'2','1','1','2'
1 row selected 
>>>  select * from ppr_test3 where ol = '2';
'key','col','ol','l'
'3','1','2','1'
'1','1','2','3'
2 rows selected 
>>>  select * from ppr_test3 where col = '1';
'key','col','ol','l'
'2','1','1','2'
'3','1','2','1'
'1','1','2','3'
3 rows selected 
>>>  select * from ppr_test3 where ol = '2' and l = '1';
'key','col','ol','l'
'3','1','2','1'
1 row selected 
>>>  select * from ppr_test3 where col='1' and ol = '2' and l = '1';
'key','col','ol','l'
'3','1','2','1'
1 row selected 
>>>  !record