PageRenderTime 51ms CodeModel.GetById 22ms RepoModel.GetById 0ms app.codeStats 0ms

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

#
text | 635 lines | 629 code | 6 blank | 0 comment | 0 complexity | d3e6c259838aeca8aedb92d67f5bf3f1 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
  1. PREHOOK: query: CREATE TABLE dest1(key INT, ten INT, one INT, value STRING) STORED AS TEXTFILE
  2. PREHOOK: type: CREATETABLE
  3. POSTHOOK: query: CREATE TABLE dest1(key INT, ten INT, one INT, value STRING) STORED AS TEXTFILE
  4. POSTHOOK: type: CREATETABLE
  5. POSTHOOK: Output: default@dest1
  6. PREHOOK: query: EXPLAIN
  7. FROM src
  8. INSERT OVERWRITE TABLE dest1
  9. SELECT src.key as c1, CAST(src.key / 10 AS INT) as c2, CAST(src.key % 10 AS INT) as c3, src.value as c4
  10. DISTRIBUTE BY c4, c1
  11. SORT BY c2 DESC, c3 ASC
  12. PREHOOK: type: QUERY
  13. POSTHOOK: query: EXPLAIN
  14. FROM src
  15. INSERT OVERWRITE TABLE dest1
  16. SELECT src.key as c1, CAST(src.key / 10 AS INT) as c2, CAST(src.key % 10 AS INT) as c3, src.value as c4
  17. DISTRIBUTE BY c4, c1
  18. SORT BY c2 DESC, c3 ASC
  19. POSTHOOK: type: QUERY
  20. ABSTRACT SYNTAX TREE:
  21. (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) key) c1) (TOK_SELEXPR (TOK_FUNCTION TOK_INT (/ (. (TOK_TABLE_OR_COL src) key) 10)) c2) (TOK_SELEXPR (TOK_FUNCTION TOK_INT (% (. (TOK_TABLE_OR_COL src) key) 10)) c3) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) value) c4)) (TOK_DISTRIBUTEBY (TOK_TABLE_OR_COL c4) (TOK_TABLE_OR_COL c1)) (TOK_SORTBY (TOK_TABSORTCOLNAMEDESC (TOK_TABLE_OR_COL c2)) (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL c3)))))
  22. STAGE DEPENDENCIES:
  23. Stage-1 is a root stage
  24. Stage-0 depends on stages: Stage-1
  25. Stage-2 depends on stages: Stage-0
  26. STAGE PLANS:
  27. Stage: Stage-1
  28. Map Reduce
  29. Alias -> Map Operator Tree:
  30. src
  31. TableScan
  32. alias: src
  33. Select Operator
  34. expressions:
  35. expr: key
  36. type: string
  37. expr: UDFToInteger((key / 10))
  38. type: int
  39. expr: UDFToInteger((key % 10))
  40. type: int
  41. expr: value
  42. type: string
  43. outputColumnNames: _col0, _col1, _col2, _col3
  44. Reduce Output Operator
  45. key expressions:
  46. expr: _col1
  47. type: int
  48. expr: _col2
  49. type: int
  50. sort order: -+
  51. Map-reduce partition columns:
  52. expr: _col3
  53. type: string
  54. expr: _col0
  55. type: string
  56. tag: -1
  57. value expressions:
  58. expr: _col0
  59. type: string
  60. expr: _col1
  61. type: int
  62. expr: _col2
  63. type: int
  64. expr: _col3
  65. type: string
  66. Reduce Operator Tree:
  67. Extract
  68. Select Operator
  69. expressions:
  70. expr: UDFToInteger(_col0)
  71. type: int
  72. expr: _col1
  73. type: int
  74. expr: _col2
  75. type: int
  76. expr: _col3
  77. type: string
  78. outputColumnNames: _col0, _col1, _col2, _col3
  79. File Output Operator
  80. compressed: false
  81. GlobalTableId: 1
  82. table:
  83. input format: org.apache.hadoop.mapred.TextInputFormat
  84. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  85. serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  86. name: default.dest1
  87. Stage: Stage-0
  88. Move Operator
  89. tables:
  90. replace: true
  91. table:
  92. input format: org.apache.hadoop.mapred.TextInputFormat
  93. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  94. serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  95. name: default.dest1
  96. Stage: Stage-2
  97. Stats-Aggr Operator
  98. PREHOOK: query: FROM src
  99. INSERT OVERWRITE TABLE dest1
  100. SELECT src.key as c1, CAST(src.key / 10 AS INT) as c2, CAST(src.key % 10 AS INT) as c3, src.value as c4
  101. DISTRIBUTE BY c4, c1
  102. SORT BY c2 DESC, c3 ASC
  103. PREHOOK: type: QUERY
  104. PREHOOK: Input: default@src
  105. PREHOOK: Output: default@dest1
  106. POSTHOOK: query: FROM src
  107. INSERT OVERWRITE TABLE dest1
  108. SELECT src.key as c1, CAST(src.key / 10 AS INT) as c2, CAST(src.key % 10 AS INT) as c3, src.value as c4
  109. DISTRIBUTE BY c4, c1
  110. SORT BY c2 DESC, c3 ASC
  111. POSTHOOK: type: QUERY
  112. POSTHOOK: Input: default@src
  113. POSTHOOK: Output: default@dest1
  114. POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  115. POSTHOOK: Lineage: dest1.one EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  116. POSTHOOK: Lineage: dest1.ten EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  117. POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
  118. PREHOOK: query: SELECT dest1.* FROM dest1
  119. PREHOOK: type: QUERY
  120. PREHOOK: Input: default@dest1
  121. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-40-15_899_2072494023559539789/-mr-10000
  122. POSTHOOK: query: SELECT dest1.* FROM dest1
  123. POSTHOOK: type: QUERY
  124. POSTHOOK: Input: default@dest1
  125. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-40-15_899_2072494023559539789/-mr-10000
  126. POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  127. POSTHOOK: Lineage: dest1.one EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  128. POSTHOOK: Lineage: dest1.ten EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  129. POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
  130. 490 49 0 val_490
  131. 491 49 1 val_491
  132. 492 49 2 val_492
  133. 492 49 2 val_492
  134. 493 49 3 val_493
  135. 494 49 4 val_494
  136. 495 49 5 val_495
  137. 496 49 6 val_496
  138. 497 49 7 val_497
  139. 498 49 8 val_498
  140. 498 49 8 val_498
  141. 498 49 8 val_498
  142. 480 48 0 val_480
  143. 480 48 0 val_480
  144. 480 48 0 val_480
  145. 481 48 1 val_481
  146. 482 48 2 val_482
  147. 483 48 3 val_483
  148. 484 48 4 val_484
  149. 485 48 5 val_485
  150. 487 48 7 val_487
  151. 489 48 9 val_489
  152. 489 48 9 val_489
  153. 489 48 9 val_489
  154. 489 48 9 val_489
  155. 470 47 0 val_470
  156. 472 47 2 val_472
  157. 475 47 5 val_475
  158. 477 47 7 val_477
  159. 478 47 8 val_478
  160. 478 47 8 val_478
  161. 479 47 9 val_479
  162. 460 46 0 val_460
  163. 462 46 2 val_462
  164. 462 46 2 val_462
  165. 463 46 3 val_463
  166. 463 46 3 val_463
  167. 466 46 6 val_466
  168. 466 46 6 val_466
  169. 466 46 6 val_466
  170. 467 46 7 val_467
  171. 468 46 8 val_468
  172. 468 46 8 val_468
  173. 468 46 8 val_468
  174. 468 46 8 val_468
  175. 469 46 9 val_469
  176. 469 46 9 val_469
  177. 469 46 9 val_469
  178. 469 46 9 val_469
  179. 469 46 9 val_469
  180. 452 45 2 val_452
  181. 453 45 3 val_453
  182. 454 45 4 val_454
  183. 454 45 4 val_454
  184. 454 45 4 val_454
  185. 455 45 5 val_455
  186. 457 45 7 val_457
  187. 458 45 8 val_458
  188. 458 45 8 val_458
  189. 459 45 9 val_459
  190. 459 45 9 val_459
  191. 443 44 3 val_443
  192. 444 44 4 val_444
  193. 446 44 6 val_446
  194. 448 44 8 val_448
  195. 449 44 9 val_449
  196. 430 43 0 val_430
  197. 430 43 0 val_430
  198. 430 43 0 val_430
  199. 431 43 1 val_431
  200. 431 43 1 val_431
  201. 431 43 1 val_431
  202. 432 43 2 val_432
  203. 435 43 5 val_435
  204. 436 43 6 val_436
  205. 437 43 7 val_437
  206. 438 43 8 val_438
  207. 438 43 8 val_438
  208. 438 43 8 val_438
  209. 439 43 9 val_439
  210. 439 43 9 val_439
  211. 421 42 1 val_421
  212. 424 42 4 val_424
  213. 424 42 4 val_424
  214. 427 42 7 val_427
  215. 429 42 9 val_429
  216. 429 42 9 val_429
  217. 411 41 1 val_411
  218. 413 41 3 val_413
  219. 413 41 3 val_413
  220. 414 41 4 val_414
  221. 414 41 4 val_414
  222. 417 41 7 val_417
  223. 417 41 7 val_417
  224. 417 41 7 val_417
  225. 418 41 8 val_418
  226. 419 41 9 val_419
  227. 400 40 0 val_400
  228. 401 40 1 val_401
  229. 401 40 1 val_401
  230. 401 40 1 val_401
  231. 401 40 1 val_401
  232. 401 40 1 val_401
  233. 402 40 2 val_402
  234. 403 40 3 val_403
  235. 403 40 3 val_403
  236. 403 40 3 val_403
  237. 404 40 4 val_404
  238. 404 40 4 val_404
  239. 406 40 6 val_406
  240. 406 40 6 val_406
  241. 406 40 6 val_406
  242. 406 40 6 val_406
  243. 407 40 7 val_407
  244. 409 40 9 val_409
  245. 409 40 9 val_409
  246. 409 40 9 val_409
  247. 392 39 2 val_392
  248. 393 39 3 val_393
  249. 394 39 4 val_394
  250. 395 39 5 val_395
  251. 395 39 5 val_395
  252. 396 39 6 val_396
  253. 396 39 6 val_396
  254. 396 39 6 val_396
  255. 397 39 7 val_397
  256. 397 39 7 val_397
  257. 399 39 9 val_399
  258. 399 39 9 val_399
  259. 382 38 2 val_382
  260. 382 38 2 val_382
  261. 384 38 4 val_384
  262. 384 38 4 val_384
  263. 384 38 4 val_384
  264. 386 38 6 val_386
  265. 389 38 9 val_389
  266. 373 37 3 val_373
  267. 374 37 4 val_374
  268. 375 37 5 val_375
  269. 377 37 7 val_377
  270. 378 37 8 val_378
  271. 379 37 9 val_379
  272. 360 36 0 val_360
  273. 362 36 2 val_362
  274. 364 36 4 val_364
  275. 365 36 5 val_365
  276. 366 36 6 val_366
  277. 367 36 7 val_367
  278. 367 36 7 val_367
  279. 368 36 8 val_368
  280. 369 36 9 val_369
  281. 369 36 9 val_369
  282. 369 36 9 val_369
  283. 351 35 1 val_351
  284. 353 35 3 val_353
  285. 353 35 3 val_353
  286. 356 35 6 val_356
  287. 341 34 1 val_341
  288. 342 34 2 val_342
  289. 342 34 2 val_342
  290. 344 34 4 val_344
  291. 344 34 4 val_344
  292. 345 34 5 val_345
  293. 348 34 8 val_348
  294. 348 34 8 val_348
  295. 348 34 8 val_348
  296. 348 34 8 val_348
  297. 348 34 8 val_348
  298. 331 33 1 val_331
  299. 331 33 1 val_331
  300. 332 33 2 val_332
  301. 333 33 3 val_333
  302. 333 33 3 val_333
  303. 335 33 5 val_335
  304. 336 33 6 val_336
  305. 338 33 8 val_338
  306. 339 33 9 val_339
  307. 321 32 1 val_321
  308. 321 32 1 val_321
  309. 322 32 2 val_322
  310. 322 32 2 val_322
  311. 323 32 3 val_323
  312. 325 32 5 val_325
  313. 325 32 5 val_325
  314. 327 32 7 val_327
  315. 327 32 7 val_327
  316. 327 32 7 val_327
  317. 310 31 0 val_310
  318. 311 31 1 val_311
  319. 311 31 1 val_311
  320. 311 31 1 val_311
  321. 315 31 5 val_315
  322. 316 31 6 val_316
  323. 316 31 6 val_316
  324. 316 31 6 val_316
  325. 317 31 7 val_317
  326. 317 31 7 val_317
  327. 318 31 8 val_318
  328. 318 31 8 val_318
  329. 318 31 8 val_318
  330. 302 30 2 val_302
  331. 305 30 5 val_305
  332. 306 30 6 val_306
  333. 307 30 7 val_307
  334. 307 30 7 val_307
  335. 308 30 8 val_308
  336. 309 30 9 val_309
  337. 309 30 9 val_309
  338. 291 29 1 val_291
  339. 292 29 2 val_292
  340. 296 29 6 val_296
  341. 298 29 8 val_298
  342. 298 29 8 val_298
  343. 298 29 8 val_298
  344. 280 28 0 val_280
  345. 280 28 0 val_280
  346. 281 28 1 val_281
  347. 281 28 1 val_281
  348. 282 28 2 val_282
  349. 282 28 2 val_282
  350. 283 28 3 val_283
  351. 284 28 4 val_284
  352. 285 28 5 val_285
  353. 286 28 6 val_286
  354. 287 28 7 val_287
  355. 288 28 8 val_288
  356. 288 28 8 val_288
  357. 289 28 9 val_289
  358. 272 27 2 val_272
  359. 272 27 2 val_272
  360. 273 27 3 val_273
  361. 273 27 3 val_273
  362. 273 27 3 val_273
  363. 274 27 4 val_274
  364. 275 27 5 val_275
  365. 277 27 7 val_277
  366. 277 27 7 val_277
  367. 277 27 7 val_277
  368. 277 27 7 val_277
  369. 278 27 8 val_278
  370. 278 27 8 val_278
  371. 260 26 0 val_260
  372. 262 26 2 val_262
  373. 263 26 3 val_263
  374. 265 26 5 val_265
  375. 265 26 5 val_265
  376. 266 26 6 val_266
  377. 252 25 2 val_252
  378. 255 25 5 val_255
  379. 255 25 5 val_255
  380. 256 25 6 val_256
  381. 256 25 6 val_256
  382. 257 25 7 val_257
  383. 258 25 8 val_258
  384. 241 24 1 val_241
  385. 242 24 2 val_242
  386. 242 24 2 val_242
  387. 244 24 4 val_244
  388. 247 24 7 val_247
  389. 248 24 8 val_248
  390. 249 24 9 val_249
  391. 230 23 0 val_230
  392. 230 23 0 val_230
  393. 230 23 0 val_230
  394. 230 23 0 val_230
  395. 230 23 0 val_230
  396. 233 23 3 val_233
  397. 233 23 3 val_233
  398. 235 23 5 val_235
  399. 237 23 7 val_237
  400. 237 23 7 val_237
  401. 238 23 8 val_238
  402. 238 23 8 val_238
  403. 239 23 9 val_239
  404. 239 23 9 val_239
  405. 221 22 1 val_221
  406. 221 22 1 val_221
  407. 222 22 2 val_222
  408. 223 22 3 val_223
  409. 223 22 3 val_223
  410. 224 22 4 val_224
  411. 224 22 4 val_224
  412. 226 22 6 val_226
  413. 228 22 8 val_228
  414. 229 22 9 val_229
  415. 229 22 9 val_229
  416. 213 21 3 val_213
  417. 213 21 3 val_213
  418. 214 21 4 val_214
  419. 216 21 6 val_216
  420. 216 21 6 val_216
  421. 217 21 7 val_217
  422. 217 21 7 val_217
  423. 218 21 8 val_218
  424. 219 21 9 val_219
  425. 219 21 9 val_219
  426. 200 20 0 val_200
  427. 200 20 0 val_200
  428. 201 20 1 val_201
  429. 202 20 2 val_202
  430. 203 20 3 val_203
  431. 203 20 3 val_203
  432. 205 20 5 val_205
  433. 205 20 5 val_205
  434. 207 20 7 val_207
  435. 207 20 7 val_207
  436. 208 20 8 val_208
  437. 208 20 8 val_208
  438. 208 20 8 val_208
  439. 209 20 9 val_209
  440. 209 20 9 val_209
  441. 190 19 0 val_190
  442. 191 19 1 val_191
  443. 191 19 1 val_191
  444. 192 19 2 val_192
  445. 193 19 3 val_193
  446. 193 19 3 val_193
  447. 193 19 3 val_193
  448. 194 19 4 val_194
  449. 195 19 5 val_195
  450. 195 19 5 val_195
  451. 196 19 6 val_196
  452. 197 19 7 val_197
  453. 197 19 7 val_197
  454. 199 19 9 val_199
  455. 199 19 9 val_199
  456. 199 19 9 val_199
  457. 180 18 0 val_180
  458. 181 18 1 val_181
  459. 183 18 3 val_183
  460. 186 18 6 val_186
  461. 187 18 7 val_187
  462. 187 18 7 val_187
  463. 187 18 7 val_187
  464. 189 18 9 val_189
  465. 170 17 0 val_170
  466. 172 17 2 val_172
  467. 172 17 2 val_172
  468. 174 17 4 val_174
  469. 174 17 4 val_174
  470. 175 17 5 val_175
  471. 175 17 5 val_175
  472. 176 17 6 val_176
  473. 176 17 6 val_176
  474. 177 17 7 val_177
  475. 178 17 8 val_178
  476. 179 17 9 val_179
  477. 179 17 9 val_179
  478. 160 16 0 val_160
  479. 162 16 2 val_162
  480. 163 16 3 val_163
  481. 164 16 4 val_164
  482. 164 16 4 val_164
  483. 165 16 5 val_165
  484. 165 16 5 val_165
  485. 166 16 6 val_166
  486. 167 16 7 val_167
  487. 167 16 7 val_167
  488. 167 16 7 val_167
  489. 168 16 8 val_168
  490. 169 16 9 val_169
  491. 169 16 9 val_169
  492. 169 16 9 val_169
  493. 169 16 9 val_169
  494. 150 15 0 val_150
  495. 152 15 2 val_152
  496. 152 15 2 val_152
  497. 153 15 3 val_153
  498. 155 15 5 val_155
  499. 156 15 6 val_156
  500. 157 15 7 val_157
  501. 158 15 8 val_158
  502. 143 14 3 val_143
  503. 145 14 5 val_145
  504. 146 14 6 val_146
  505. 146 14 6 val_146
  506. 149 14 9 val_149
  507. 149 14 9 val_149
  508. 131 13 1 val_131
  509. 133 13 3 val_133
  510. 134 13 4 val_134
  511. 134 13 4 val_134
  512. 136 13 6 val_136
  513. 137 13 7 val_137
  514. 137 13 7 val_137
  515. 138 13 8 val_138
  516. 138 13 8 val_138
  517. 138 13 8 val_138
  518. 138 13 8 val_138
  519. 120 12 0 val_120
  520. 120 12 0 val_120
  521. 125 12 5 val_125
  522. 125 12 5 val_125
  523. 126 12 6 val_126
  524. 128 12 8 val_128
  525. 128 12 8 val_128
  526. 128 12 8 val_128
  527. 129 12 9 val_129
  528. 129 12 9 val_129
  529. 111 11 1 val_111
  530. 113 11 3 val_113
  531. 113 11 3 val_113
  532. 114 11 4 val_114
  533. 116 11 6 val_116
  534. 118 11 8 val_118
  535. 118 11 8 val_118
  536. 119 11 9 val_119
  537. 119 11 9 val_119
  538. 119 11 9 val_119
  539. 100 10 0 val_100
  540. 100 10 0 val_100
  541. 103 10 3 val_103
  542. 103 10 3 val_103
  543. 104 10 4 val_104
  544. 104 10 4 val_104
  545. 105 10 5 val_105
  546. 90 9 0 val_90
  547. 90 9 0 val_90
  548. 90 9 0 val_90
  549. 92 9 2 val_92
  550. 95 9 5 val_95
  551. 95 9 5 val_95
  552. 96 9 6 val_96
  553. 97 9 7 val_97
  554. 97 9 7 val_97
  555. 98 9 8 val_98
  556. 98 9 8 val_98
  557. 80 8 0 val_80
  558. 82 8 2 val_82
  559. 83 8 3 val_83
  560. 83 8 3 val_83
  561. 84 8 4 val_84
  562. 84 8 4 val_84
  563. 85 8 5 val_85
  564. 86 8 6 val_86
  565. 87 8 7 val_87
  566. 70 7 0 val_70
  567. 70 7 0 val_70
  568. 70 7 0 val_70
  569. 72 7 2 val_72
  570. 72 7 2 val_72
  571. 74 7 4 val_74
  572. 76 7 6 val_76
  573. 76 7 6 val_76
  574. 77 7 7 val_77
  575. 78 7 8 val_78
  576. 64 6 4 val_64
  577. 65 6 5 val_65
  578. 66 6 6 val_66
  579. 67 6 7 val_67
  580. 67 6 7 val_67
  581. 69 6 9 val_69
  582. 51 5 1 val_51
  583. 51 5 1 val_51
  584. 53 5 3 val_53
  585. 54 5 4 val_54
  586. 57 5 7 val_57
  587. 58 5 8 val_58
  588. 58 5 8 val_58
  589. 41 4 1 val_41
  590. 42 4 2 val_42
  591. 42 4 2 val_42
  592. 43 4 3 val_43
  593. 44 4 4 val_44
  594. 47 4 7 val_47
  595. 30 3 0 val_30
  596. 33 3 3 val_33
  597. 34 3 4 val_34
  598. 35 3 5 val_35
  599. 35 3 5 val_35
  600. 35 3 5 val_35
  601. 37 3 7 val_37
  602. 37 3 7 val_37
  603. 20 2 0 val_20
  604. 24 2 4 val_24
  605. 24 2 4 val_24
  606. 26 2 6 val_26
  607. 26 2 6 val_26
  608. 27 2 7 val_27
  609. 28 2 8 val_28
  610. 10 1 0 val_10
  611. 11 1 1 val_11
  612. 12 1 2 val_12
  613. 12 1 2 val_12
  614. 15 1 5 val_15
  615. 15 1 5 val_15
  616. 17 1 7 val_17
  617. 18 1 8 val_18
  618. 18 1 8 val_18
  619. 19 1 9 val_19
  620. 0 0 0 val_0
  621. 0 0 0 val_0
  622. 0 0 0 val_0
  623. 2 0 2 val_2
  624. 4 0 4 val_4
  625. 5 0 5 val_5
  626. 5 0 5 val_5
  627. 5 0 5 val_5
  628. 8 0 8 val_8
  629. 9 0 9 val_9