Saving all output to "!!{outputDirectory}!!/misc_json.q.raw". Enter "record" with no arguments to stop it.
>>>  !run !!{qFileDirectory}!!/misc_json.q
>>>  set hive.ddl.output.format=json;
No rows affected 
>>>  
>>>  CREATE TABLE IF NOT EXISTS jsontable (key INT, value STRING) COMMENT 'json table' STORED AS TEXTFILE;
No rows affected 
>>>  
>>>  ALTER TABLE jsontable ADD COLUMNS (name STRING COMMENT 'a new column');
No rows affected 
>>>  
>>>  ALTER TABLE jsontable RENAME TO jsontable2;
No rows affected 
>>>  
>>>  SHOW TABLE EXTENDED LIKE jsontable2;
'tab_name'
'{"tables":[{"minFileSize":0,"totalNumberFiles":0,"location":"!!{hive.metastore.warehouse.dir}!!/misc_json.db/jsontable2","outputFormat":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat","lastAccessTime":0,"lastUpdateTime":!!UNIXTIMEMILLIS!!,"columns":[{"name":"key","type":"int"},{"name":"value","type":"string"},{"name":"name","comment":"a new column","type":"string"}],"maxFileSize":0,"partitioned":false,"tableName":"jsontable2","owner":"!!{user.name}!!","inputFormat":"org.apache.hadoop.mapred.TextInputFormat","totalFileSize":0}]}'
1 row selected 
>>>  
>>>  DROP TABLE jsontable2;
No rows affected 
>>>  
>>>  set hive.ddl.output.format=text;
No rows affected 
>>>  !record