Saving all output to "!!{outputDirectory}!!/drop_partitions_filter2.q.raw". Enter "record" with no arguments to stop it.
>>>  !run !!{qFileDirectory}!!/drop_partitions_filter2.q
>>>  create table ptestfilter (a string, b int) partitioned by (c int, d int);
No rows affected 
>>>  describe ptestfilter;
'col_name','data_type','comment'
'a','string',''
'b','int',''
'c','int',''
'd','int',''
4 rows selected 
>>>  
>>>  alter table ptestfilter add partition (c=1, d=1);
No rows affected 
>>>  alter table ptestfilter add partition (c=1, d=2);
No rows affected 
>>>  alter table ptestFilter add partition (c=2, d=1);
No rows affected 
>>>  alter table ptestfilter add partition (c=2, d=2);
No rows affected 
>>>  alter table ptestfilter add partition (c=3, d=1);
No rows affected 
>>>  alter table ptestfilter add partition (c=3, d=2);
No rows affected 
>>>  show partitions ptestfilter;
'partition'
'c=1/d=1'
'c=1/d=2'
'c=2/d=1'
'c=2/d=2'
'c=3/d=1'
'c=3/d=2'
6 rows selected 
>>>  
>>>  alter table ptestfilter drop partition (c=1, d=1);
No rows affected 
>>>  show partitions ptestfilter;
'partition'
'c=1/d=2'
'c=2/d=1'
'c=2/d=2'
'c=3/d=1'
'c=3/d=2'
5 rows selected 
>>>  
>>>  alter table ptestfilter drop partition (c=2);
No rows affected 
>>>  show partitions ptestfilter;
'partition'
'c=1/d=2'
'c=3/d=1'
'c=3/d=2'
3 rows selected 
>>>  
>>>  drop table ptestfilter;
No rows affected 
>>>  
>>>  
>>>  !record