PageRenderTime 24ms CodeModel.GetById 12ms app.highlight 6ms RepoModel.GetById 1ms app.codeStats 1ms

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

#
text | 455 lines | 448 code | 7 blank | 0 comment | 0 complexity | eb7a32b79c919077fde101a4eee613b1 MD5 | raw file
  1PREHOOK: query: CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@dest_g1
  6PREHOOK: query: EXPLAIN
  7FROM src INSERT OVERWRITE TABLE dest_g1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
  8PREHOOK: type: QUERY
  9POSTHOOK: query: EXPLAIN
 10FROM src INSERT OVERWRITE TABLE dest_g1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
 11POSTHOOK: type: QUERY
 12ABSTRACT SYNTAX TREE:
 13  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest_g1))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) key)) (TOK_SELEXPR (TOK_FUNCTION sum (TOK_FUNCTION substr (. (TOK_TABLE_OR_COL src) value) 5)))) (TOK_GROUPBY (. (TOK_TABLE_OR_COL src) key))))
 14
 15STAGE DEPENDENCIES:
 16  Stage-1 is a root stage
 17  Stage-2 depends on stages: Stage-1
 18  Stage-0 depends on stages: Stage-2
 19  Stage-3 depends on stages: Stage-0
 20
 21STAGE PLANS:
 22  Stage: Stage-1
 23    Map Reduce
 24      Alias -> Map Operator Tree:
 25        src 
 26          TableScan
 27            alias: src
 28            Select Operator
 29              expressions:
 30                    expr: key
 31                    type: string
 32                    expr: value
 33                    type: string
 34              outputColumnNames: key, value
 35              Reduce Output Operator
 36                key expressions:
 37                      expr: key
 38                      type: string
 39                sort order: +
 40                Map-reduce partition columns:
 41                      expr: rand()
 42                      type: double
 43                tag: -1
 44                value expressions:
 45                      expr: substr(value, 5)
 46                      type: string
 47      Reduce Operator Tree:
 48        Group By Operator
 49          aggregations:
 50                expr: sum(VALUE._col0)
 51          bucketGroup: false
 52          keys:
 53                expr: KEY._col0
 54                type: string
 55          mode: partial1
 56          outputColumnNames: _col0, _col1
 57          File Output Operator
 58            compressed: false
 59            GlobalTableId: 0
 60            table:
 61                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
 62                output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
 63
 64  Stage: Stage-2
 65    Map Reduce
 66      Alias -> Map Operator Tree:
 67        file:/tmp/sdong/hive_2011-02-10_01-48-28_322_6836842616937387407/-mr-10002 
 68            Reduce Output Operator
 69              key expressions:
 70                    expr: _col0
 71                    type: string
 72              sort order: +
 73              Map-reduce partition columns:
 74                    expr: _col0
 75                    type: string
 76              tag: -1
 77              value expressions:
 78                    expr: _col1
 79                    type: double
 80      Reduce Operator Tree:
 81        Group By Operator
 82          aggregations:
 83                expr: sum(VALUE._col0)
 84          bucketGroup: false
 85          keys:
 86                expr: KEY._col0
 87                type: string
 88          mode: final
 89          outputColumnNames: _col0, _col1
 90          Select Operator
 91            expressions:
 92                  expr: _col0
 93                  type: string
 94                  expr: _col1
 95                  type: double
 96            outputColumnNames: _col0, _col1
 97            Select Operator
 98              expressions:
 99                    expr: UDFToInteger(_col0)
100                    type: int
101                    expr: _col1
102                    type: double
103              outputColumnNames: _col0, _col1
104              File Output Operator
105                compressed: false
106                GlobalTableId: 1
107                table:
108                    input format: org.apache.hadoop.mapred.TextInputFormat
109                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
110                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
111                    name: default.dest_g1
112
113  Stage: Stage-0
114    Move Operator
115      tables:
116          replace: true
117          table:
118              input format: org.apache.hadoop.mapred.TextInputFormat
119              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
120              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
121              name: default.dest_g1
122
123  Stage: Stage-3
124    Stats-Aggr Operator
125
126
127PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest_g1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
128PREHOOK: type: QUERY
129PREHOOK: Input: default@src
130PREHOOK: Output: default@dest_g1
131POSTHOOK: query: FROM src INSERT OVERWRITE TABLE dest_g1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key
132POSTHOOK: type: QUERY
133POSTHOOK: Input: default@src
134POSTHOOK: Output: default@dest_g1
135POSTHOOK: Lineage: dest_g1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
136POSTHOOK: Lineage: dest_g1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
137PREHOOK: query: SELECT dest_g1.* FROM dest_g1
138PREHOOK: type: QUERY
139PREHOOK: Input: default@dest_g1
140PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-48-36_158_2449754649383665745/-mr-10000
141POSTHOOK: query: SELECT dest_g1.* FROM dest_g1
142POSTHOOK: type: QUERY
143POSTHOOK: Input: default@dest_g1
144POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-48-36_158_2449754649383665745/-mr-10000
145POSTHOOK: Lineage: dest_g1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
146POSTHOOK: Lineage: dest_g1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
1470	0.0
14810	10.0
149100	200.0
150103	206.0
151104	208.0
152105	105.0
15311	11.0
154111	111.0
155113	226.0
156114	114.0
157116	116.0
158118	236.0
159119	357.0
16012	24.0
161120	240.0
162125	250.0
163126	126.0
164128	384.0
165129	258.0
166131	131.0
167133	133.0
168134	268.0
169136	136.0
170137	274.0
171138	552.0
172143	143.0
173145	145.0
174146	292.0
175149	298.0
17615	30.0
177150	150.0
178152	304.0
179153	153.0
180155	155.0
181156	156.0
182157	157.0
183158	158.0
184160	160.0
185162	162.0
186163	163.0
187164	328.0
188165	330.0
189166	166.0
190167	501.0
191168	168.0
192169	676.0
19317	17.0
194170	170.0
195172	344.0
196174	348.0
197175	350.0
198176	352.0
199177	177.0
200178	178.0
201179	358.0
20218	36.0
203180	180.0
204181	181.0
205183	183.0
206186	186.0
207187	561.0
208189	189.0
20919	19.0
210190	190.0
211191	382.0
212192	192.0
213193	579.0
214194	194.0
215195	390.0
216196	196.0
217197	394.0
218199	597.0
2192	2.0
22020	20.0
221200	400.0
222201	201.0
223202	202.0
224203	406.0
225205	410.0
226207	414.0
227208	624.0
228209	418.0
229213	426.0
230214	214.0
231216	432.0
232217	434.0
233218	218.0
234219	438.0
235221	442.0
236222	222.0
237223	446.0
238224	448.0
239226	226.0
240228	228.0
241229	458.0
242230	1150.0
243233	466.0
244235	235.0
245237	474.0
246238	476.0
247239	478.0
24824	48.0
249241	241.0
250242	484.0
251244	244.0
252247	247.0
253248	248.0
254249	249.0
255252	252.0
256255	510.0
257256	512.0
258257	257.0
259258	258.0
26026	52.0
261260	260.0
262262	262.0
263263	263.0
264265	530.0
265266	266.0
26627	27.0
267272	544.0
268273	819.0
269274	274.0
270275	275.0
271277	1108.0
272278	556.0
27328	28.0
274280	560.0
275281	562.0
276282	564.0
277283	283.0
278284	284.0
279285	285.0
280286	286.0
281287	287.0
282288	576.0
283289	289.0
284291	291.0
285292	292.0
286296	296.0
287298	894.0
28830	30.0
289302	302.0
290305	305.0
291306	306.0
292307	614.0
293308	308.0
294309	618.0
295310	310.0
296311	933.0
297315	315.0
298316	948.0
299317	634.0
300318	954.0
301321	642.0
302322	644.0
303323	323.0
304325	650.0
305327	981.0
30633	33.0
307331	662.0
308332	332.0
309333	666.0
310335	335.0
311336	336.0
312338	338.0
313339	339.0
31434	34.0
315341	341.0
316342	684.0
317344	688.0
318345	345.0
319348	1740.0
32035	105.0
321351	351.0
322353	706.0
323356	356.0
324360	360.0
325362	362.0
326364	364.0
327365	365.0
328366	366.0
329367	734.0
330368	368.0
331369	1107.0
33237	74.0
333373	373.0
334374	374.0
335375	375.0
336377	377.0
337378	378.0
338379	379.0
339382	764.0
340384	1152.0
341386	386.0
342389	389.0
343392	392.0
344393	393.0
345394	394.0
346395	790.0
347396	1188.0
348397	794.0
349399	798.0
3504	4.0
351400	400.0
352401	2005.0
353402	402.0
354403	1209.0
355404	808.0
356406	1624.0
357407	407.0
358409	1227.0
35941	41.0
360411	411.0
361413	826.0
362414	828.0
363417	1251.0
364418	418.0
365419	419.0
36642	84.0
367421	421.0
368424	848.0
369427	427.0
370429	858.0
37143	43.0
372430	1290.0
373431	1293.0
374432	432.0
375435	435.0
376436	436.0
377437	437.0
378438	1314.0
379439	878.0
38044	44.0
381443	443.0
382444	444.0
383446	446.0
384448	448.0
385449	449.0
386452	452.0
387453	453.0
388454	1362.0
389455	455.0
390457	457.0
391458	916.0
392459	918.0
393460	460.0
394462	924.0
395463	926.0
396466	1398.0
397467	467.0
398468	1872.0
399469	2345.0
40047	47.0
401470	470.0
402472	472.0
403475	475.0
404477	477.0
405478	956.0
406479	479.0
407480	1440.0
408481	481.0
409482	482.0
410483	483.0
411484	484.0
412485	485.0
413487	487.0
414489	1956.0
415490	490.0
416491	491.0
417492	984.0
418493	493.0
419494	494.0
420495	495.0
421496	496.0
422497	497.0
423498	1494.0
4245	15.0
42551	102.0
42653	53.0
42754	54.0
42857	57.0
42958	116.0
43064	64.0
43165	65.0
43266	66.0
43367	134.0
43469	69.0
43570	210.0
43672	144.0
43774	74.0
43876	152.0
43977	77.0
44078	78.0
4418	8.0
44280	80.0
44382	82.0
44483	166.0
44584	168.0
44685	85.0
44786	86.0
44887	87.0
4499	9.0
45090	270.0
45192	92.0
45295	190.0
45396	96.0
45497	194.0
45598	196.0