Saving all output to "!!{outputDirectory}!!/describe_table_json.q.raw". Enter "record" with no arguments to stop it.
>>>  !run !!{qFileDirectory}!!/describe_table_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 
>>>  
>>>  SHOW TABLES;
'tab_name'
'{"tables":["jsontable","primitives","src","src1","src_json","src_sequencefile","src_thrift","srcbucket","srcbucket2","srcpart"]}'
1 row selected 
>>>  
>>>  SHOW TABLES LIKE 'json*';
'tab_name'
'{"tables":["jsontable"]}'
1 row selected 
>>>  
>>>  SHOW TABLE EXTENDED LIKE 'json*';
'tab_name'
'{"tables":[]}'
1 row selected 
>>>  
>>>  ALTER TABLE jsontable SET TBLPROPERTIES ('id' = 'jsontable');
No rows affected 
>>>  
>>>  DESCRIBE jsontable;
'col_name','data_type','comment'
'{"columns":[{"name":"key","type":"int"},{"name":"value","type":"string"}]}','',''
1 row selected 
>>>  
>>>  DESCRIBE extended jsontable;
'col_name','data_type','comment'
'{"columns":[{"name":"key","type":"int"},{"name":"value","type":"string"}],"tableInfo":{"owner":"!!{user.name}!!","parameters":{"id":"jsontable","last_modified_by":"!!{user.name}!!","last_modified_time":"!!UNIXTIME!!","transient_lastDdlTime":"!!UNIXTIME!!","comment":"json table"},"tableName":"jsontable","dbName":"describe_table_json","tableType":"MANAGED_TABLE","sd":{"location":"!!{hive.metastore.warehouse.dir}!!/describe_table_json.db/jsontable","parameters":{},"inputFormat":"org.apache.hadoop.mapred.TextInputFormat","outputFormat":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat","cols":[{"name":"key","type":"int","comment":null,"setName":true,"setType":true,"setComment":false},{"name":"value","type":"string","comment":null,"setName":true,"setType":true,"setComment":false}],"skewedInfo":{"skewedColNames":[],"skewedColValues":[],"skewedColValueLocationMaps":{},"skewedColNamesSize":0,"skewedColNamesIterator":[],"setSkewedColNames":true,"skewedColValuesSize":0,"skewedColValuesIterator":[],"setSkewedColValues":true,"skewedColValueLocationMapsSize":0,"setSkewedColValueLocationMaps":true},"serdeInfo":{"name":null,"parameters":{"serialization.format":"1"},"serializationLib":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","setName":false,"parametersSize":1,"setParameters":true,"setSerializationLib":true},"numBuckets":-1,"bucketCols":[],"compressed":false,"sortCols":[],"parametersSize":0,"setParameters":true,"colsSize":2,"colsIterator":[{"name":"key","type":"int","comment":null,"setName":true,"setType":true,"setComment":false},{"name":"value","type":"string","comment":null,"setName":true,"setType":true,"setComment":false}],"setCols":true,"setLocation":true,"setInputFormat":true,"setOutputFormat":true,"setCompressed":true,"setNumBuckets":true,"setSerdeInfo":true,"bucketColsSize":0,"bucketColsIterator":[],"setBucketCols":true,"sortColsSize":0,"sortColsIterator":[],"setSortCols":true,"setSkewedInfo":true},"partitionKeys":[],"createTime":!!UNIXTIME!!,"privileges":null,"viewOriginalText":null,"lastAccessTime":0,"retention":0,"viewExpandedText":null,"partitionKeysSize":0,"setDbName":true,"setCreateTime":true,"setLastAccessTime":true,"setSd":true,"parametersSize":5,"setParameters":true,"setTableName":true,"setOwner":true,"setRetention":true,"partitionKeysIterator":[],"setPartitionKeys":true,"setViewOriginalText":false,"setViewExpandedText":false,"setTableType":true,"setPrivileges":false}}','',''
1 row selected 
>>>  
>>>  DROP TABLE jsontable;
No rows affected 
>>>  
>>>  set hive.ddl.output.format=text;
No rows affected 
>>>  !record