ql/src/test/results/clientpositive/fileformat_sequencefile.q.out

PREHOOK: query: EXPLAIN
CREATE TABLE dest1_n85(key INT, value STRING) STORED AS
  INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat'
  OUTPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileOutputFormat'
PREHOOK: type: CREATETABLE
POSTHOOK: query: EXPLAIN
CREATE TABLE dest1_n85(key INT, value STRING) STORED AS
  INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat'
  OUTPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileOutputFormat'
POSTHOOK: type: CREATETABLE
STAGE DEPENDENCIES:
  Stage-0 is a root stage

STAGE PLANS:
  Stage: Stage-0
      Create Table Operator:
        Create Table
          columns: key int, value string
          input format: org.apache.hadoop.mapred.SequenceFileInputFormat
          output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
          name: default.dest1_n85

PREHOOK: query: CREATE TABLE dest1_n85(key INT, value STRING) STORED AS
  INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat'
  OUTPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileOutputFormat'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@dest1_n85
POSTHOOK: query: CREATE TABLE dest1_n85(key INT, value STRING) STORED AS
  INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat'
  OUTPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileOutputFormat'
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1_n85
PREHOOK: query: DESCRIBE EXTENDED dest1_n85
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@dest1_n85
POSTHOOK: query: DESCRIBE EXTENDED dest1_n85
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@dest1_n85
key                 	int                 	                    
value               	string              	                    
	 	 
#### A masked pattern was here ####
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1_n85 SELECT src.key, src.value WHERE src.key < 10
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@dest1_n85
POSTHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1_n85 SELECT src.key, src.value WHERE src.key < 10
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest1_n85
POSTHOOK: Lineage: dest1_n85.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1_n85.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: SELECT dest1_n85.* FROM dest1_n85
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1_n85
#### A masked pattern was here ####
POSTHOOK: query: SELECT dest1_n85.* FROM dest1_n85
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1_n85
#### A masked pattern was here ####
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