PageRenderTime 18ms CodeModel.GetById 9ms app.highlight 5ms RepoModel.GetById 1ms app.codeStats 1ms

/tags/release-0.0.0-rc0/hive/external/ql/src/test/results/clientpositive/input_dynamicserde.q.out

#
text | 164 lines | 155 code | 9 blank | 0 comment | 0 complexity | b4ddcd17dc7812160d806bc85596c502 MD5 | raw file
  1PREHOOK: query: CREATE TABLE dest1(a array<int>, b array<string>, c map<string,string>, d int, e string)
  2ROW FORMAT DELIMITED
  3FIELDS TERMINATED BY '1'
  4COLLECTION ITEMS TERMINATED BY '2'
  5MAP KEYS TERMINATED BY '3'
  6LINES TERMINATED BY '10'
  7STORED AS TEXTFILE
  8PREHOOK: type: CREATETABLE
  9POSTHOOK: query: CREATE TABLE dest1(a array<int>, b array<string>, c map<string,string>, d int, e string)
 10ROW FORMAT DELIMITED
 11FIELDS TERMINATED BY '1'
 12COLLECTION ITEMS TERMINATED BY '2'
 13MAP KEYS TERMINATED BY '3'
 14LINES TERMINATED BY '10'
 15STORED AS TEXTFILE
 16POSTHOOK: type: CREATETABLE
 17POSTHOOK: Output: default@dest1
 18PREHOOK: query: EXPLAIN
 19FROM src_thrift
 20INSERT OVERWRITE TABLE dest1 SELECT src_thrift.lint, src_thrift.lstring, src_thrift.mstringstring, src_thrift.aint, src_thrift.astring
 21PREHOOK: type: QUERY
 22POSTHOOK: query: EXPLAIN
 23FROM src_thrift
 24INSERT OVERWRITE TABLE dest1 SELECT src_thrift.lint, src_thrift.lstring, src_thrift.mstringstring, src_thrift.aint, src_thrift.astring
 25POSTHOOK: type: QUERY
 26ABSTRACT SYNTAX TREE:
 27  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src_thrift))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src_thrift) lint)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src_thrift) lstring)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src_thrift) mstringstring)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src_thrift) aint)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src_thrift) astring)))))
 28
 29STAGE DEPENDENCIES:
 30  Stage-1 is a root stage
 31  Stage-5 depends on stages: Stage-1 , consists of Stage-4, Stage-3
 32  Stage-4
 33  Stage-0 depends on stages: Stage-4, Stage-3
 34  Stage-2 depends on stages: Stage-0
 35  Stage-3
 36
 37STAGE PLANS:
 38  Stage: Stage-1
 39    Map Reduce
 40      Alias -> Map Operator Tree:
 41        src_thrift 
 42          TableScan
 43            alias: src_thrift
 44            Select Operator
 45              expressions:
 46                    expr: lint
 47                    type: array<int>
 48                    expr: lstring
 49                    type: array<string>
 50                    expr: mstringstring
 51                    type: map<string,string>
 52                    expr: aint
 53                    type: int
 54                    expr: astring
 55                    type: string
 56              outputColumnNames: _col0, _col1, _col2, _col3, _col4
 57              File Output Operator
 58                compressed: false
 59                GlobalTableId: 1
 60                table:
 61                    input format: org.apache.hadoop.mapred.TextInputFormat
 62                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 63                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 64                    name: default.dest1
 65
 66  Stage: Stage-5
 67    Conditional Operator
 68
 69  Stage: Stage-4
 70    Move Operator
 71      files:
 72          hdfs directory: true
 73          destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_15-59-04_148_5887480461717684622/-ext-10000
 74
 75  Stage: Stage-0
 76    Move Operator
 77      tables:
 78          replace: true
 79          table:
 80              input format: org.apache.hadoop.mapred.TextInputFormat
 81              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 82              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 83              name: default.dest1
 84
 85  Stage: Stage-2
 86    Stats-Aggr Operator
 87
 88  Stage: Stage-3
 89    Map Reduce
 90      Alias -> Map Operator Tree:
 91        pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_15-59-04_148_5887480461717684622/-ext-10002 
 92            File Output Operator
 93              compressed: false
 94              GlobalTableId: 0
 95              table:
 96                  input format: org.apache.hadoop.mapred.TextInputFormat
 97                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 98                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 99                  name: default.dest1
100
101
102PREHOOK: query: FROM src_thrift
103INSERT OVERWRITE TABLE dest1 SELECT src_thrift.lint, src_thrift.lstring, src_thrift.mstringstring, src_thrift.aint, src_thrift.astring
104PREHOOK: type: QUERY
105PREHOOK: Input: default@src_thrift
106PREHOOK: Output: default@dest1
107POSTHOOK: query: FROM src_thrift
108INSERT OVERWRITE TABLE dest1 SELECT src_thrift.lint, src_thrift.lstring, src_thrift.mstringstring, src_thrift.aint, src_thrift.astring
109POSTHOOK: type: QUERY
110POSTHOOK: Input: default@src_thrift
111POSTHOOK: Output: default@dest1
112POSTHOOK: Lineage: dest1.a SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), ]
113POSTHOOK: Lineage: dest1.b SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lstring, type:array<string>, comment:from deserializer), ]
114POSTHOOK: Lineage: dest1.c SIMPLE [(src_thrift)src_thrift.FieldSchema(name:mstringstring, type:map<string,string>, comment:from deserializer), ]
115POSTHOOK: Lineage: dest1.d SIMPLE [(src_thrift)src_thrift.FieldSchema(name:aint, type:int, comment:from deserializer), ]
116POSTHOOK: Lineage: dest1.e SIMPLE [(src_thrift)src_thrift.FieldSchema(name:astring, type:string, comment:from deserializer), ]
117PREHOOK: query: SELECT dest1.* FROM dest1
118PREHOOK: type: QUERY
119PREHOOK: Input: default@dest1
120PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-59-10_716_5166904835235075338/-mr-10000
121POSTHOOK: query: SELECT dest1.* FROM dest1
122POSTHOOK: type: QUERY
123POSTHOOK: Input: default@dest1
124POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-59-10_716_5166904835235075338/-mr-10000
125POSTHOOK: Lineage: dest1.a SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), ]
126POSTHOOK: Lineage: dest1.b SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lstring, type:array<string>, comment:from deserializer), ]
127POSTHOOK: Lineage: dest1.c SIMPLE [(src_thrift)src_thrift.FieldSchema(name:mstringstring, type:map<string,string>, comment:from deserializer), ]
128POSTHOOK: Lineage: dest1.d SIMPLE [(src_thrift)src_thrift.FieldSchema(name:aint, type:int, comment:from deserializer), ]
129POSTHOOK: Lineage: dest1.e SIMPLE [(src_thrift)src_thrift.FieldSchema(name:astring, type:string, comment:from deserializer), ]
130[0,0,0]	["0","0","0"]	{"key_0":"value_0"}	1712634731	record_0
131[1,2,3]	["10","100","1000"]	{"key_1":"value_1"}	465985200	record_1
132[2,4,6]	["20","200","2000"]	{"key_2":"value_2"}	-751827638	record_2
133[3,6,9]	["30","300","3000"]	{"key_3":"value_3"}	477111222	record_3
134[4,8,12]	["40","400","4000"]	{"key_4":"value_4"}	-734328909	record_4
135[5,10,15]	["50","500","5000"]	{"key_5":"value_5"}	-1952710710	record_5
136[6,12,18]	["60","600","6000"]	{"key_6":"value_6"}	1244525190	record_6
137[7,14,21]	["70","700","7000"]	{"key_7":"value_7"}	-1461153973	record_7
138[8,16,24]	["80","800","8000"]	{"key_8":"value_8"}	1638581578	record_8
139[9,18,27]	["90","900","9000"]	{"key_9":"value_9"}	336964413	record_9
140null	null	null	0	NULL
141PREHOOK: query: SELECT dest1.a[0], dest1.b[0], dest1.c['key2'], dest1.d, dest1.e FROM dest1
142PREHOOK: type: QUERY
143PREHOOK: Input: default@dest1
144PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-59-10_996_1166370053409806128/-mr-10000
145POSTHOOK: query: SELECT dest1.a[0], dest1.b[0], dest1.c['key2'], dest1.d, dest1.e FROM dest1
146POSTHOOK: type: QUERY
147POSTHOOK: Input: default@dest1
148POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-59-10_996_1166370053409806128/-mr-10000
149POSTHOOK: Lineage: dest1.a SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lint, type:array<int>, comment:from deserializer), ]
150POSTHOOK: Lineage: dest1.b SIMPLE [(src_thrift)src_thrift.FieldSchema(name:lstring, type:array<string>, comment:from deserializer), ]
151POSTHOOK: Lineage: dest1.c SIMPLE [(src_thrift)src_thrift.FieldSchema(name:mstringstring, type:map<string,string>, comment:from deserializer), ]
152POSTHOOK: Lineage: dest1.d SIMPLE [(src_thrift)src_thrift.FieldSchema(name:aint, type:int, comment:from deserializer), ]
153POSTHOOK: Lineage: dest1.e SIMPLE [(src_thrift)src_thrift.FieldSchema(name:astring, type:string, comment:from deserializer), ]
1540	0	NULL	1712634731	record_0
1551	10	NULL	465985200	record_1
1562	20	NULL	-751827638	record_2
1573	30	NULL	477111222	record_3
1584	40	NULL	-734328909	record_4
1595	50	NULL	-1952710710	record_5
1606	60	NULL	1244525190	record_6
1617	70	NULL	-1461153973	record_7
1628	80	NULL	1638581578	record_8
1639	90	NULL	336964413	record_9
164NULL	NULL	NULL	0	NULL