PageRenderTime 24ms CodeModel.GetById 18ms app.highlight 3ms RepoModel.GetById 1ms app.codeStats 0ms

/tags/release-0.2.0-rc0/hive/external/contrib/src/test/results/clientpositive/udf_row_sequence.q.out

#
text | 659 lines | 651 code | 8 blank | 0 comment | 0 complexity | a4cab7dde69228d2e9b8154c0b3a2460 MD5 | raw file
  1PREHOOK: query: -- The ORDER BY on the outer query will typically have no effect,
  2-- but there is really no guarantee that the ordering is preserved
  3-- across various SQL operators.
  4
  5drop temporary function row_sequence
  6PREHOOK: type: DROPFUNCTION
  7POSTHOOK: query: -- The ORDER BY on the outer query will typically have no effect,
  8-- but there is really no guarantee that the ordering is preserved
  9-- across various SQL operators.
 10
 11drop temporary function row_sequence
 12POSTHOOK: type: DROPFUNCTION
 13PREHOOK: query: create temporary function row_sequence as 
 14'org.apache.hadoop.hive.contrib.udf.UDFRowSequence'
 15PREHOOK: type: CREATEFUNCTION
 16POSTHOOK: query: create temporary function row_sequence as 
 17'org.apache.hadoop.hive.contrib.udf.UDFRowSequence'
 18POSTHOOK: type: CREATEFUNCTION
 19PREHOOK: query: DESCRIBE FUNCTION EXTENDED row_sequence
 20PREHOOK: type: DESCFUNCTION
 21POSTHOOK: query: DESCRIBE FUNCTION EXTENDED row_sequence
 22POSTHOOK: type: DESCFUNCTION
 23row_sequence() - Returns a generated row sequence number starting from 1
 24PREHOOK: query: explain
 25select key, row_sequence() as r
 26from (select key from src order by key) x
 27order by r
 28PREHOOK: type: QUERY
 29POSTHOOK: query: explain
 30select key, row_sequence() as r
 31from (select key from src order by key) x
 32order by r
 33POSTHOOK: type: QUERY
 34ABSTRACT SYNTAX TREE:
 35  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL key))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL key))))) x)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL key)) (TOK_SELEXPR (TOK_FUNCTION row_sequence) r)) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL r)))))
 36
 37STAGE DEPENDENCIES:
 38  Stage-1 is a root stage
 39  Stage-2 depends on stages: Stage-1
 40  Stage-0 is a root stage
 41
 42STAGE PLANS:
 43  Stage: Stage-1
 44    Map Reduce
 45      Alias -> Map Operator Tree:
 46        x:src 
 47          TableScan
 48            alias: src
 49            Select Operator
 50              expressions:
 51                    expr: key
 52                    type: string
 53              outputColumnNames: _col0
 54              Reduce Output Operator
 55                key expressions:
 56                      expr: _col0
 57                      type: string
 58                sort order: +
 59                tag: -1
 60                value expressions:
 61                      expr: _col0
 62                      type: string
 63      Reduce Operator Tree:
 64        Extract
 65          Select Operator
 66            expressions:
 67                  expr: _col0
 68                  type: string
 69                  expr: row_sequence()
 70                  type: bigint
 71            outputColumnNames: _col0, _col1
 72            File Output Operator
 73              compressed: false
 74              GlobalTableId: 0
 75              table:
 76                  input format: org.apache.hadoop.mapred.SequenceFileInputFormat
 77                  output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
 78
 79  Stage: Stage-2
 80    Map Reduce
 81      Alias -> Map Operator Tree:
 82        file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-02-22_22-26-27_614_6714509994567553903/-mr-10002 
 83            Reduce Output Operator
 84              key expressions:
 85                    expr: _col1
 86                    type: bigint
 87              sort order: +
 88              tag: -1
 89              value expressions:
 90                    expr: _col0
 91                    type: string
 92                    expr: _col1
 93                    type: bigint
 94      Reduce Operator Tree:
 95        Extract
 96          File Output Operator
 97            compressed: false
 98            GlobalTableId: 0
 99            table:
100                input format: org.apache.hadoop.mapred.TextInputFormat
101                output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
102
103  Stage: Stage-0
104    Fetch Operator
105      limit: -1
106
107
108PREHOOK: query: select key, row_sequence() as r
109from (select key from src order by key) x
110order by r
111PREHOOK: type: QUERY
112PREHOOK: Input: default@src
113PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-02-22_22-26-27_973_4395636849347592535/-mr-10000
114POSTHOOK: query: select key, row_sequence() as r
115from (select key from src order by key) x
116order by r
117POSTHOOK: type: QUERY
118POSTHOOK: Input: default@src
119POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-02-22_22-26-27_973_4395636849347592535/-mr-10000
1200	1
1210	2
1220	3
12310	4
124100	5
125100	6
126103	7
127103	8
128104	9
129104	10
130105	11
13111	12
132111	13
133113	14
134113	15
135114	16
136116	17
137118	18
138118	19
139119	20
140119	21
141119	22
14212	23
14312	24
144120	25
145120	26
146125	27
147125	28
148126	29
149128	30
150128	31
151128	32
152129	33
153129	34
154131	35
155133	36
156134	37
157134	38
158136	39
159137	40
160137	41
161138	42
162138	43
163138	44
164138	45
165143	46
166145	47
167146	48
168146	49
169149	50
170149	51
17115	52
17215	53
173150	54
174152	55
175152	56
176153	57
177155	58
178156	59
179157	60
180158	61
181160	62
182162	63
183163	64
184164	65
185164	66
186165	67
187165	68
188166	69
189167	70
190167	71
191167	72
192168	73
193169	74
194169	75
195169	76
196169	77
19717	78
198170	79
199172	80
200172	81
201174	82
202174	83
203175	84
204175	85
205176	86
206176	87
207177	88
208178	89
209179	90
210179	91
21118	92
21218	93
213180	94
214181	95
215183	96
216186	97
217187	98
218187	99
219187	100
220189	101
22119	102
222190	103
223191	104
224191	105
225192	106
226193	107
227193	108
228193	109
229194	110
230195	111
231195	112
232196	113
233197	114
234197	115
235199	116
236199	117
237199	118
2382	119
23920	120
240200	121
241200	122
242201	123
243202	124
244203	125
245203	126
246205	127
247205	128
248207	129
249207	130
250208	131
251208	132
252208	133
253209	134
254209	135
255213	136
256213	137
257214	138
258216	139
259216	140
260217	141
261217	142
262218	143
263219	144
264219	145
265221	146
266221	147
267222	148
268223	149
269223	150
270224	151
271224	152
272226	153
273228	154
274229	155
275229	156
276230	157
277230	158
278230	159
279230	160
280230	161
281233	162
282233	163
283235	164
284237	165
285237	166
286238	167
287238	168
288239	169
289239	170
29024	171
29124	172
292241	173
293242	174
294242	175
295244	176
296247	177
297248	178
298249	179
299252	180
300255	181
301255	182
302256	183
303256	184
304257	185
305258	186
30626	187
30726	188
308260	189
309262	190
310263	191
311265	192
312265	193
313266	194
31427	195
315272	196
316272	197
317273	198
318273	199
319273	200
320274	201
321275	202
322277	203
323277	204
324277	205
325277	206
326278	207
327278	208
32828	209
329280	210
330280	211
331281	212
332281	213
333282	214
334282	215
335283	216
336284	217
337285	218
338286	219
339287	220
340288	221
341288	222
342289	223
343291	224
344292	225
345296	226
346298	227
347298	228
348298	229
34930	230
350302	231
351305	232
352306	233
353307	234
354307	235
355308	236
356309	237
357309	238
358310	239
359311	240
360311	241
361311	242
362315	243
363316	244
364316	245
365316	246
366317	247
367317	248
368318	249
369318	250
370318	251
371321	252
372321	253
373322	254
374322	255
375323	256
376325	257
377325	258
378327	259
379327	260
380327	261
38133	262
382331	263
383331	264
384332	265
385333	266
386333	267
387335	268
388336	269
389338	270
390339	271
39134	272
392341	273
393342	274
394342	275
395344	276
396344	277
397345	278
398348	279
399348	280
400348	281
401348	282
402348	283
40335	284
40435	285
40535	286
406351	287
407353	288
408353	289
409356	290
410360	291
411362	292
412364	293
413365	294
414366	295
415367	296
416367	297
417368	298
418369	299
419369	300
420369	301
42137	302
42237	303
423373	304
424374	305
425375	306
426377	307
427378	308
428379	309
429382	310
430382	311
431384	312
432384	313
433384	314
434386	315
435389	316
436392	317
437393	318
438394	319
439395	320
440395	321
441396	322
442396	323
443396	324
444397	325
445397	326
446399	327
447399	328
4484	329
449400	330
450401	331
451401	332
452401	333
453401	334
454401	335
455402	336
456403	337
457403	338
458403	339
459404	340
460404	341
461406	342
462406	343
463406	344
464406	345
465407	346
466409	347
467409	348
468409	349
46941	350
470411	351
471413	352
472413	353
473414	354
474414	355
475417	356
476417	357
477417	358
478418	359
479419	360
48042	361
48142	362
482421	363
483424	364
484424	365
485427	366
486429	367
487429	368
48843	369
489430	370
490430	371
491430	372
492431	373
493431	374
494431	375
495432	376
496435	377
497436	378
498437	379
499438	380
500438	381
501438	382
502439	383
503439	384
50444	385
505443	386
506444	387
507446	388
508448	389
509449	390
510452	391
511453	392
512454	393
513454	394
514454	395
515455	396
516457	397
517458	398
518458	399
519459	400
520459	401
521460	402
522462	403
523462	404
524463	405
525463	406
526466	407
527466	408
528466	409
529467	410
530468	411
531468	412
532468	413
533468	414
534469	415
535469	416
536469	417
537469	418
538469	419
53947	420
540470	421
541472	422
542475	423
543477	424
544478	425
545478	426
546479	427
547480	428
548480	429
549480	430
550481	431
551482	432
552483	433
553484	434
554485	435
555487	436
556489	437
557489	438
558489	439
559489	440
560490	441
561491	442
562492	443
563492	444
564493	445
565494	446
566495	447
567496	448
568497	449
569498	450
570498	451
571498	452
5725	453
5735	454
5745	455
57551	456
57651	457
57753	458
57854	459
57957	460
58058	461
58158	462
58264	463
58365	464
58466	465
58567	466
58667	467
58769	468
58870	469
58970	470
59070	471
59172	472
59272	473
59374	474
59476	475
59576	476
59677	477
59778	478
5988	479
59980	480
60082	481
60183	482
60283	483
60384	484
60484	485
60585	486
60686	487
60787	488
6089	489
60990	490
61090	491
61190	492
61292	493
61395	494
61495	495
61596	496
61697	497
61797	498
61898	499
61998	500
620PREHOOK: query: -- make sure stateful functions do not get short-circuited away
621-- a true result for key=105 would indicate undesired short-circuiting
622select key, (key = 105) and (row_sequence() = 1)
623from (select key from src order by key) x
624order by key limit 20
625PREHOOK: type: QUERY
626PREHOOK: Input: default@src
627PREHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-02-22_22-26-43_815_3305291736093408641/-mr-10000
628POSTHOOK: query: -- make sure stateful functions do not get short-circuited away
629-- a true result for key=105 would indicate undesired short-circuiting
630select key, (key = 105) and (row_sequence() = 1)
631from (select key from src order by key) x
632order by key limit 20
633POSTHOOK: type: QUERY
634POSTHOOK: Input: default@src
635POSTHOOK: Output: file:/var/folders/7P/7PeC14kXFIWq0PIYyexGbmKuXUk/-Tmp-/jsichi/hive_2011-02-22_22-26-43_815_3305291736093408641/-mr-10000
6360	false
6370	false
6380	false
63910	false
640100	false
641100	false
642103	false
643103	false
644104	false
645104	false
646105	false
64711	false
648111	false
649113	false
650113	false
651114	false
652116	false
653118	false
654118	false
655119	false
656PREHOOK: query: drop temporary function row_sequence
657PREHOOK: type: DROPFUNCTION
658POSTHOOK: query: drop temporary function row_sequence
659POSTHOOK: type: DROPFUNCTION