PageRenderTime 10ms CodeModel.GetById 6ms app.highlight 2ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 467 lines | 461 code | 6 blank | 0 comment | 0 complexity | ad23bcb0b2e03a14855529cfdba9856f MD5 | raw file
  1PREHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@dest1
  6PREHOOK: query: EXPLAIN
  7FROM (
  8  FROM src
  9  MAP src.key, src.key 
 10  USING 'cat'
 11  DISTRIBUTE BY key
 12  SORT BY key, value
 13) tmap
 14INSERT OVERWRITE TABLE dest1
 15REDUCE tmap.key, tmap.value
 16USING 'input20_script'
 17AS (key STRING, value STRING)
 18PREHOOK: type: QUERY
 19POSTHOOK: query: EXPLAIN
 20FROM (
 21  FROM src
 22  MAP src.key, src.key 
 23  USING 'cat'
 24  DISTRIBUTE BY key
 25  SORT BY key, value
 26) tmap
 27INSERT OVERWRITE TABLE dest1
 28REDUCE tmap.key, tmap.value
 29USING 'input20_script'
 30AS (key STRING, value STRING)
 31POSTHOOK: type: QUERY
 32ABSTRACT SYNTAX TREE:
 33  (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_TRANSFORM (TOK_EXPLIST (. (TOK_TABLE_OR_COL src) key) (. (TOK_TABLE_OR_COL src) key)) TOK_SERDE TOK_RECORDWRITER 'cat' TOK_SERDE TOK_RECORDREADER))) (TOK_DISTRIBUTEBY (TOK_TABLE_OR_COL key)) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL key)) (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL value))))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_EXPLIST (. (TOK_TABLE_OR_COL tmap) key) (. (TOK_TABLE_OR_COL tmap) value)) TOK_SERDE TOK_RECORDWRITER 'input20_script' TOK_SERDE TOK_RECORDREADER (TOK_TABCOLLIST (TOK_TABCOL key TOK_STRING) (TOK_TABCOL value TOK_STRING)))))))
 34
 35STAGE DEPENDENCIES:
 36  Stage-1 is a root stage
 37  Stage-0 depends on stages: Stage-1
 38  Stage-2 depends on stages: Stage-0
 39
 40STAGE PLANS:
 41  Stage: Stage-1
 42    Map Reduce
 43      Alias -> Map Operator Tree:
 44        tmap:src 
 45          TableScan
 46            alias: src
 47            Select Operator
 48              expressions:
 49                    expr: key
 50                    type: string
 51                    expr: key
 52                    type: string
 53              outputColumnNames: _col0, _col1
 54              Transform Operator
 55                command: cat
 56                output info:
 57                    input format: org.apache.hadoop.mapred.TextInputFormat
 58                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 59                Reduce Output Operator
 60                  key expressions:
 61                        expr: _col0
 62                        type: string
 63                        expr: _col1
 64                        type: string
 65                  sort order: ++
 66                  Map-reduce partition columns:
 67                        expr: _col0
 68                        type: string
 69                  tag: -1
 70                  value expressions:
 71                        expr: _col0
 72                        type: string
 73                        expr: _col1
 74                        type: string
 75      Reduce Operator Tree:
 76        Extract
 77          Select Operator
 78            expressions:
 79                  expr: _col0
 80                  type: string
 81                  expr: _col1
 82                  type: string
 83            outputColumnNames: _col0, _col1
 84            Transform Operator
 85              command: input20_script
 86              output info:
 87                  input format: org.apache.hadoop.mapred.TextInputFormat
 88                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 89              Select Operator
 90                expressions:
 91                      expr: UDFToInteger(_col0)
 92                      type: int
 93                      expr: _col1
 94                      type: string
 95                outputColumnNames: _col0, _col1
 96                File Output Operator
 97                  compressed: false
 98                  GlobalTableId: 1
 99                  table:
100                      input format: org.apache.hadoop.mapred.TextInputFormat
101                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
102                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
103                      name: default.dest1
104
105  Stage: Stage-0
106    Move Operator
107      tables:
108          replace: true
109          table:
110              input format: org.apache.hadoop.mapred.TextInputFormat
111              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
112              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
113              name: default.dest1
114
115  Stage: Stage-2
116    Stats-Aggr Operator
117
118
119PREHOOK: query: FROM (
120  FROM src
121  MAP src.key, src.key
122  USING 'cat' 
123  DISTRIBUTE BY key
124  SORT BY key, value
125) tmap
126INSERT OVERWRITE TABLE dest1
127REDUCE tmap.key, tmap.value
128USING 'input20_script'
129AS (key STRING, value STRING)
130PREHOOK: type: QUERY
131PREHOOK: Input: default@src
132PREHOOK: Output: default@dest1
133POSTHOOK: query: FROM (
134  FROM src
135  MAP src.key, src.key
136  USING 'cat' 
137  DISTRIBUTE BY key
138  SORT BY key, value
139) tmap
140INSERT OVERWRITE TABLE dest1
141REDUCE tmap.key, tmap.value
142USING 'input20_script'
143AS (key STRING, value STRING)
144POSTHOOK: type: QUERY
145POSTHOOK: Input: default@src
146POSTHOOK: Output: default@dest1
147POSTHOOK: Lineage: dest1.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), ]
148POSTHOOK: Lineage: dest1.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), ]
149PREHOOK: query: SELECT * FROM dest1 SORT BY key, value
150PREHOOK: type: QUERY
151PREHOOK: Input: default@dest1
152PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-55-32_693_8757115489547146865/-mr-10000
153POSTHOOK: query: SELECT * FROM dest1 SORT BY key, value
154POSTHOOK: type: QUERY
155POSTHOOK: Input: default@dest1
156POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-55-32_693_8757115489547146865/-mr-10000
157POSTHOOK: Lineage: dest1.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), ]
158POSTHOOK: Lineage: dest1.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), ]
1591	105_105
1601	10_10
1611	111_111
1621	114_114
1631	116_116
1641	11_11
1651	126_126
1661	131_131
1671	133_133
1681	136_136
1691	143_143
1701	145_145
1711	150_150
1721	153_153
1731	155_155
1741	156_156
1751	157_157
1761	158_158
1771	160_160
1781	162_162
1791	163_163
1801	166_166
1811	168_168
1821	170_170
1831	177_177
1841	178_178
1851	17_17
1861	180_180
1871	181_181
1881	183_183
1891	186_186
1901	189_189
1911	190_190
1921	192_192
1931	194_194
1941	196_196
1951	19_19
1961	201_201
1971	202_202
1981	20_20
1991	214_214
2001	218_218
2011	222_222
2021	226_226
2031	228_228
2041	235_235
2051	241_241
2061	244_244
2071	247_247
2081	248_248
2091	249_249
2101	252_252
2111	257_257
2121	258_258
2131	260_260
2141	262_262
2151	263_263
2161	266_266
2171	274_274
2181	275_275
2191	27_27
2201	283_283
2211	284_284
2221	285_285
2231	286_286
2241	287_287
2251	289_289
2261	28_28
2271	291_291
2281	292_292
2291	296_296
2301	2_2
2311	302_302
2321	305_305
2331	306_306
2341	308_308
2351	30_30
2361	310_310
2371	315_315
2381	323_323
2391	332_332
2401	335_335
2411	336_336
2421	338_338
2431	339_339
2441	33_33
2451	341_341
2461	345_345
2471	34_34
2481	351_351
2491	356_356
2501	360_360
2511	362_362
2521	364_364
2531	365_365
2541	366_366
2551	368_368
2561	373_373
2571	374_374
2581	375_375
2591	377_377
2601	378_378
2611	379_379
2621	386_386
2631	389_389
2641	392_392
2651	393_393
2661	394_394
2671	400_400
2681	402_402
2691	407_407
2701	411_411
2711	418_418
2721	419_419
2731	41_41
2741	421_421
2751	427_427
2761	432_432
2771	435_435
2781	436_436
2791	437_437
2801	43_43
2811	443_443
2821	444_444
2831	446_446
2841	448_448
2851	449_449
2861	44_44
2871	452_452
2881	453_453
2891	455_455
2901	457_457
2911	460_460
2921	467_467
2931	470_470
2941	472_472
2951	475_475
2961	477_477
2971	479_479
2981	47_47
2991	481_481
3001	482_482
3011	483_483
3021	484_484
3031	485_485
3041	487_487
3051	490_490
3061	491_491
3071	493_493
3081	494_494
3091	495_495
3101	496_496
3111	497_497
3121	4_4
3131	53_53
3141	54_54
3151	57_57
3161	64_64
3171	65_65
3181	66_66
3191	69_69
3201	74_74
3211	77_77
3221	78_78
3231	80_80
3241	82_82
3251	85_85
3261	86_86
3271	87_87
3281	8_8
3291	92_92
3301	96_96
3311	9_9
3322	100_100
3332	103_103
3342	104_104
3352	113_113
3362	118_118
3372	120_120
3382	125_125
3392	129_129
3402	12_12
3412	134_134
3422	137_137
3432	146_146
3442	149_149
3452	152_152
3462	15_15
3472	164_164
3482	165_165
3492	172_172
3502	174_174
3512	175_175
3522	176_176
3532	179_179
3542	18_18
3552	191_191
3562	195_195
3572	197_197
3582	200_200
3592	203_203
3602	205_205
3612	207_207
3622	209_209
3632	213_213
3642	216_216
3652	217_217
3662	219_219
3672	221_221
3682	223_223
3692	224_224
3702	229_229
3712	233_233
3722	237_237
3732	238_238
3742	239_239
3752	242_242
3762	24_24
3772	255_255
3782	256_256
3792	265_265
3802	26_26
3812	272_272
3822	278_278
3832	280_280
3842	281_281
3852	282_282
3862	288_288
3872	307_307
3882	309_309
3892	317_317
3902	321_321
3912	322_322
3922	325_325
3932	331_331
3942	333_333
3952	342_342
3962	344_344
3972	353_353
3982	367_367
3992	37_37
4002	382_382
4012	395_395
4022	397_397
4032	399_399
4042	404_404
4052	413_413
4062	414_414
4072	424_424
4082	429_429
4092	42_42
4102	439_439
4112	458_458
4122	459_459
4132	462_462
4142	463_463
4152	478_478
4162	492_492
4172	51_51
4182	58_58
4192	67_67
4202	72_72
4212	76_76
4222	83_83
4232	84_84
4242	95_95
4252	97_97
4262	98_98
4273	0_0
4283	119_119
4293	128_128
4303	167_167
4313	187_187
4323	193_193
4333	199_199
4343	208_208
4353	273_273
4363	298_298
4373	311_311
4383	316_316
4393	318_318
4403	327_327
4413	35_35
4423	369_369
4433	384_384
4443	396_396
4453	403_403
4463	409_409
4473	417_417
4483	430_430
4493	431_431
4503	438_438
4513	454_454
4523	466_466
4533	480_480
4543	498_498
4553	5_5
4563	70_70
4573	90_90
4584	138_138
4594	169_169
4604	277_277
4614	406_406
4624	468_468
4634	489_489
4645	230_230
4655	348_348
4665	401_401
4675	469_469