Saving all output to "!!{outputDirectory}!!/partitions_json.q.raw". Enter "record" with no arguments to stop it.
>>>  !run !!{qFileDirectory}!!/partitions_json.q
>>>  set hive.ddl.output.format=json;
No rows affected 
>>>  
>>>  CREATE TABLE add_part_test (key STRING, value STRING) PARTITIONED BY (ds STRING);
No rows affected 
>>>  SHOW PARTITIONS add_part_test;
'partition'
'{"partitions":[]}'
1 row selected 
>>>  
>>>  ALTER TABLE add_part_test ADD PARTITION (ds='2010-01-01');
No rows affected 
>>>  SHOW PARTITIONS add_part_test;
'partition'
'{"partitions":[{"values":[{"columnName":"ds","columnValue":"2010-01-01"}],"name":"ds='2010-01-01'"}]}'
1 row selected 
>>>  
>>>  ALTER TABLE add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-01');
No rows affected 
>>>  SHOW PARTITIONS add_part_test;
'partition'
'{"partitions":[{"values":[{"columnName":"ds","columnValue":"2010-01-01"}],"name":"ds='2010-01-01'"}]}'
1 row selected 
>>>  
>>>  ALTER TABLE add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-02');
No rows affected 
>>>  SHOW PARTITIONS add_part_test;
'partition'
'{"partitions":[{"values":[{"columnName":"ds","columnValue":"2010-01-01"}],"name":"ds='2010-01-01'"},{"values":[{"columnName":"ds","columnValue":"2010-01-02"}],"name":"ds='2010-01-02'"}]}'
1 row selected 
>>>  
>>>  SHOW TABLE EXTENDED LIKE add_part_test PARTITION (ds='2010-01-02');
'tab_name'
'{"tables":[{"minFileSize":0,"totalNumberFiles":0,"location":"!!{hive.metastore.warehouse.dir}!!/partitions_json.db/add_part_test/ds=2010-01-02","lastUpdateTime":!!UNIXTIMEMILLIS!!,"outputFormat":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat","lastAccessTime":0,"columns":[{"name":"key","type":"string"},{"name":"value","type":"string"}],"partitionColumns":[{"name":"ds","type":"string"}],"maxFileSize":0,"partitioned":true,"tableName":"add_part_test","owner":"!!{user.name}!!","inputFormat":"org.apache.hadoop.mapred.TextInputFormat","totalFileSize":0}]}'
1 row selected 
>>>  
>>>  ALTER TABLE add_part_test DROP PARTITION (ds='2010-01-02');
No rows affected 
>>>  
>>>  DROP TABLE add_part_test;
No rows affected 
>>>  
>>>  set hive.ddl.output.format=text;
No rows affected 
>>>  !record