Saving all output to "!!{outputDirectory}!!/fileformat_sequencefile.q.raw". Enter "record" with no arguments to stop it.
>>>  !run !!{qFileDirectory}!!/fileformat_sequencefile.q
>>>  EXPLAIN 
CREATE TABLE dest1(key INT, value STRING) STORED AS 
INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat' 
OUTPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileOutputFormat';
'Explain'
'ABSTRACT SYNTAX TREE:'
'  (TOK_CREATETABLE (TOK_TABNAME dest1) TOK_LIKETABLE (TOK_TABCOLLIST (TOK_TABCOL key TOK_INT) (TOK_TABCOL value TOK_STRING)) (TOK_TABLEFILEFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat' 'org.apache.hadoop.mapred.SequenceFileOutputFormat'))'
''
'STAGE DEPENDENCIES:'
'  Stage-0 is a root stage'
''
'STAGE PLANS:'
'  Stage: Stage-0'
'      Create Table Operator:'
'        Create Table'
'          columns: key int, value string'
'          if not exists: false'
'          input format: org.apache.hadoop.mapred.SequenceFileInputFormat'
'          # buckets: -1'
'          output format: org.apache.hadoop.mapred.SequenceFileOutputFormat'
'          name: dest1'
'          isExternal: false'
''
''
19 rows selected 
>>>  
>>>  CREATE TABLE dest1(key INT, value STRING) STORED AS 
INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat' 
OUTPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileOutputFormat';
No rows affected 
>>>  
>>>  DESCRIBE EXTENDED dest1;
'col_name','data_type','comment'
'key','int',''
'value','string',''
'','',''
'Detailed Table Information','Table(tableName:dest1, dbName:fileformat_sequencefile, owner:!!{user.name}!!, createTime:!!UNIXTIME!!, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:!!{hive.metastore.warehouse.dir}!!/fileformat_sequencefile.db/dest1, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}, skewedInfo:SkewedInfo(skewedColNames:[], skewedColValues:[], skewedColValueLocationMaps:{})), partitionKeys:[], parameters:{transient_lastDdlTime=!!UNIXTIME!!}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)',''
4 rows selected 
>>>  
>>>  FROM src 
INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 10;
'_col0','_col1'
No rows selected 
>>>  
>>>  SELECT dest1.* FROM dest1;
'key','value'
'0','val_0'
'4','val_4'
'8','val_8'
'0','val_0'
'0','val_0'
'5','val_5'
'5','val_5'
'2','val_2'
'5','val_5'
'9','val_9'
10 rows selected 
>>>  
>>>  
>>>  !record