query: EXPLAIN
CREATE TABLE dest1(key INT, value STRING) STORED AS
  INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat'
  OUTPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileOutputFormat'
ABSTRACT SYNTAX TREE:
  (TOK_CREATETABLE 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


query: CREATE TABLE dest1(key INT, value STRING) STORED AS
  INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat'
  OUTPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileOutputFormat'
query: DESCRIBE EXTENDED dest1
key	int	
value	string	
	 	 
Detailed Table Information	Table(tableName:dest1,dbName:default,owner:zshao,createTime:1243543756,lastAccessTime:0,retention:0,sd:StorageDescriptor(cols:[FieldSchema(name:key,type:int,comment:null), FieldSchema(name:value,type:string,comment:null)],location:file:/data/users/zshao/tools/495-trunk-apache-hive/build/ql/test/data/warehouse/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:{}),partitionKeys:[],parameters:{})	
query: FROM src
INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 10
Input: default/src
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
Output: file:/data/users/zshao/tools/495-trunk-apache-hive/build/ql/tmp/1703595747/10000
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
query: DROP TABLE dest1