PageRenderTime 44ms CodeModel.GetById 16ms RepoModel.GetById 1ms app.codeStats 0ms

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

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