PageRenderTime 20ms CodeModel.GetById 15ms app.highlight 2ms RepoModel.GetById 1ms app.codeStats 0ms

/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out

#
text | 78 lines | 73 code | 5 blank | 0 comment | 0 complexity | db906efaa2f1b1aaddd72af353976ba0 MD5 | raw file
 1PREHOOK: query: EXPLAIN
 2CREATE TABLE dest1(key INT, value STRING) STORED AS
 3  INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat'
 4  OUTPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileOutputFormat'
 5PREHOOK: type: CREATETABLE
 6POSTHOOK: query: EXPLAIN
 7CREATE TABLE dest1(key INT, value STRING) STORED AS
 8  INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat'
 9  OUTPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileOutputFormat'
10POSTHOOK: type: CREATETABLE
11ABSTRACT SYNTAX TREE:
12  (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'))
13
14STAGE DEPENDENCIES:
15  Stage-0 is a root stage
16
17STAGE PLANS:
18  Stage: Stage-0
19      Create Table Operator:
20        Create Table
21          columns: key int, value string
22          if not exists: false
23          input format: org.apache.hadoop.mapred.SequenceFileInputFormat
24          # buckets: -1
25          output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
26          name: dest1
27          isExternal: false
28
29
30PREHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS
31  INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat'
32  OUTPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileOutputFormat'
33PREHOOK: type: CREATETABLE
34POSTHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS
35  INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat'
36  OUTPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileOutputFormat'
37POSTHOOK: type: CREATETABLE
38POSTHOOK: Output: default@dest1
39PREHOOK: query: DESCRIBE EXTENDED dest1
40PREHOOK: type: DESCTABLE
41POSTHOOK: query: DESCRIBE EXTENDED dest1
42POSTHOOK: type: DESCTABLE
43key	int	
44value	string	
45	 	 
46Detailed Table Information	Table(tableName:dest1, dbName:default, owner:sdong, createTime:1297331254, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/data/users/sdong/www/open-source-hive1/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:{transient_lastDdlTime=1297331254}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
47PREHOOK: query: FROM src
48INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 10
49PREHOOK: type: QUERY
50PREHOOK: Input: default@src
51PREHOOK: Output: default@dest1
52POSTHOOK: query: FROM src
53INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 10
54POSTHOOK: type: QUERY
55POSTHOOK: Input: default@src
56POSTHOOK: Output: default@dest1
57POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
58POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
59PREHOOK: query: SELECT dest1.* FROM dest1
60PREHOOK: type: QUERY
61PREHOOK: Input: default@dest1
62PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-47-38_871_2911208910534048188/-mr-10000
63POSTHOOK: query: SELECT dest1.* FROM dest1
64POSTHOOK: type: QUERY
65POSTHOOK: Input: default@dest1
66POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-47-38_871_2911208910534048188/-mr-10000
67POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
68POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
690	val_0
704	val_4
718	val_8
720	val_0
730	val_0
745	val_5
755	val_5
762	val_2
775	val_5
789	val_9