PageRenderTime 50ms CodeModel.GetById 17ms RepoModel.GetById 0ms app.codeStats 0ms

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

#
text | 1274 lines | 1249 code | 25 blank | 0 comment | 0 complexity | c8b0194490a9f8d129c05a3de9a97cc6 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
  1. PREHOOK: query: EXPLAIN SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3
  2. PREHOOK: type: QUERY
  3. POSTHOOK: query: EXPLAIN SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3
  4. POSTHOOK: type: QUERY
  5. ABSTRACT SYNTAX TREE:
  6. (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL value)) c)) (TOK_GROUPBY (TOK_TABLE_OR_COL key)) (TOK_HAVING (> (TOK_TABLE_OR_COL c) 3))))
  7. STAGE DEPENDENCIES:
  8. Stage-1 is a root stage
  9. Stage-0 is a root stage
  10. STAGE PLANS:
  11. Stage: Stage-1
  12. Map Reduce
  13. Alias -> Map Operator Tree:
  14. src
  15. TableScan
  16. alias: src
  17. Select Operator
  18. expressions:
  19. expr: key
  20. type: string
  21. expr: value
  22. type: string
  23. outputColumnNames: key, value
  24. Group By Operator
  25. aggregations:
  26. expr: count(value)
  27. bucketGroup: false
  28. keys:
  29. expr: key
  30. type: string
  31. mode: hash
  32. outputColumnNames: _col0, _col1
  33. Reduce Output Operator
  34. key expressions:
  35. expr: _col0
  36. type: string
  37. sort order: +
  38. Map-reduce partition columns:
  39. expr: _col0
  40. type: string
  41. tag: -1
  42. value expressions:
  43. expr: _col1
  44. type: bigint
  45. Reduce Operator Tree:
  46. Group By Operator
  47. aggregations:
  48. expr: count(VALUE._col0)
  49. bucketGroup: false
  50. keys:
  51. expr: KEY._col0
  52. type: string
  53. mode: mergepartial
  54. outputColumnNames: _col0, _col1
  55. Filter Operator
  56. predicate:
  57. expr: (_col1 > 3)
  58. type: boolean
  59. Select Operator
  60. expressions:
  61. expr: _col1
  62. type: bigint
  63. outputColumnNames: _col0
  64. File Output Operator
  65. compressed: false
  66. GlobalTableId: 0
  67. table:
  68. input format: org.apache.hadoop.mapred.TextInputFormat
  69. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  70. Stage: Stage-0
  71. Fetch Operator
  72. limit: -1
  73. PREHOOK: query: SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3
  74. PREHOOK: type: QUERY
  75. PREHOOK: Input: default@src
  76. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-55-25_061_1887192452567405688/-mr-10000
  77. POSTHOOK: query: SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3
  78. POSTHOOK: type: QUERY
  79. POSTHOOK: Input: default@src
  80. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-55-25_061_1887192452567405688/-mr-10000
  81. 4
  82. 4
  83. 5
  84. 4
  85. 5
  86. 5
  87. 4
  88. 4
  89. 5
  90. 4
  91. PREHOOK: query: EXPLAIN SELECT key, max(value) AS c FROM src GROUP BY key HAVING key != 302
  92. PREHOOK: type: QUERY
  93. POSTHOOK: query: EXPLAIN SELECT key, max(value) AS c FROM src GROUP BY key HAVING key != 302
  94. POSTHOOK: type: QUERY
  95. ABSTRACT SYNTAX TREE:
  96. (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_SELEXPR (TOK_FUNCTION max (TOK_TABLE_OR_COL value)) c)) (TOK_GROUPBY (TOK_TABLE_OR_COL key)) (TOK_HAVING (!= (TOK_TABLE_OR_COL key) 302))))
  97. STAGE DEPENDENCIES:
  98. Stage-1 is a root stage
  99. Stage-0 is a root stage
  100. STAGE PLANS:
  101. Stage: Stage-1
  102. Map Reduce
  103. Alias -> Map Operator Tree:
  104. src
  105. TableScan
  106. alias: src
  107. Filter Operator
  108. predicate:
  109. expr: (key <> 302)
  110. type: boolean
  111. Select Operator
  112. expressions:
  113. expr: key
  114. type: string
  115. expr: value
  116. type: string
  117. outputColumnNames: key, value
  118. Group By Operator
  119. aggregations:
  120. expr: max(value)
  121. bucketGroup: false
  122. keys:
  123. expr: key
  124. type: string
  125. mode: hash
  126. outputColumnNames: _col0, _col1
  127. Reduce Output Operator
  128. key expressions:
  129. expr: _col0
  130. type: string
  131. sort order: +
  132. Map-reduce partition columns:
  133. expr: _col0
  134. type: string
  135. tag: -1
  136. value expressions:
  137. expr: _col1
  138. type: string
  139. Reduce Operator Tree:
  140. Group By Operator
  141. aggregations:
  142. expr: max(VALUE._col0)
  143. bucketGroup: false
  144. keys:
  145. expr: KEY._col0
  146. type: string
  147. mode: mergepartial
  148. outputColumnNames: _col0, _col1
  149. Select Operator
  150. expressions:
  151. expr: _col0
  152. type: string
  153. expr: _col1
  154. type: string
  155. outputColumnNames: _col0, _col1
  156. File Output Operator
  157. compressed: false
  158. GlobalTableId: 0
  159. table:
  160. input format: org.apache.hadoop.mapred.TextInputFormat
  161. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  162. Stage: Stage-0
  163. Fetch Operator
  164. limit: -1
  165. PREHOOK: query: SELECT key, max(value) AS c FROM src GROUP BY key HAVING key != 302
  166. PREHOOK: type: QUERY
  167. PREHOOK: Input: default@src
  168. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-55-28_939_197667381386821930/-mr-10000
  169. POSTHOOK: query: SELECT key, max(value) AS c FROM src GROUP BY key HAVING key != 302
  170. POSTHOOK: type: QUERY
  171. POSTHOOK: Input: default@src
  172. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-55-28_939_197667381386821930/-mr-10000
  173. 0 val_0
  174. 10 val_10
  175. 100 val_100
  176. 103 val_103
  177. 104 val_104
  178. 105 val_105
  179. 11 val_11
  180. 111 val_111
  181. 113 val_113
  182. 114 val_114
  183. 116 val_116
  184. 118 val_118
  185. 119 val_119
  186. 12 val_12
  187. 120 val_120
  188. 125 val_125
  189. 126 val_126
  190. 128 val_128
  191. 129 val_129
  192. 131 val_131
  193. 133 val_133
  194. 134 val_134
  195. 136 val_136
  196. 137 val_137
  197. 138 val_138
  198. 143 val_143
  199. 145 val_145
  200. 146 val_146
  201. 149 val_149
  202. 15 val_15
  203. 150 val_150
  204. 152 val_152
  205. 153 val_153
  206. 155 val_155
  207. 156 val_156
  208. 157 val_157
  209. 158 val_158
  210. 160 val_160
  211. 162 val_162
  212. 163 val_163
  213. 164 val_164
  214. 165 val_165
  215. 166 val_166
  216. 167 val_167
  217. 168 val_168
  218. 169 val_169
  219. 17 val_17
  220. 170 val_170
  221. 172 val_172
  222. 174 val_174
  223. 175 val_175
  224. 176 val_176
  225. 177 val_177
  226. 178 val_178
  227. 179 val_179
  228. 18 val_18
  229. 180 val_180
  230. 181 val_181
  231. 183 val_183
  232. 186 val_186
  233. 187 val_187
  234. 189 val_189
  235. 19 val_19
  236. 190 val_190
  237. 191 val_191
  238. 192 val_192
  239. 193 val_193
  240. 194 val_194
  241. 195 val_195
  242. 196 val_196
  243. 197 val_197
  244. 199 val_199
  245. 2 val_2
  246. 20 val_20
  247. 200 val_200
  248. 201 val_201
  249. 202 val_202
  250. 203 val_203
  251. 205 val_205
  252. 207 val_207
  253. 208 val_208
  254. 209 val_209
  255. 213 val_213
  256. 214 val_214
  257. 216 val_216
  258. 217 val_217
  259. 218 val_218
  260. 219 val_219
  261. 221 val_221
  262. 222 val_222
  263. 223 val_223
  264. 224 val_224
  265. 226 val_226
  266. 228 val_228
  267. 229 val_229
  268. 230 val_230
  269. 233 val_233
  270. 235 val_235
  271. 237 val_237
  272. 238 val_238
  273. 239 val_239
  274. 24 val_24
  275. 241 val_241
  276. 242 val_242
  277. 244 val_244
  278. 247 val_247
  279. 248 val_248
  280. 249 val_249
  281. 252 val_252
  282. 255 val_255
  283. 256 val_256
  284. 257 val_257
  285. 258 val_258
  286. 26 val_26
  287. 260 val_260
  288. 262 val_262
  289. 263 val_263
  290. 265 val_265
  291. 266 val_266
  292. 27 val_27
  293. 272 val_272
  294. 273 val_273
  295. 274 val_274
  296. 275 val_275
  297. 277 val_277
  298. 278 val_278
  299. 28 val_28
  300. 280 val_280
  301. 281 val_281
  302. 282 val_282
  303. 283 val_283
  304. 284 val_284
  305. 285 val_285
  306. 286 val_286
  307. 287 val_287
  308. 288 val_288
  309. 289 val_289
  310. 291 val_291
  311. 292 val_292
  312. 296 val_296
  313. 298 val_298
  314. 30 val_30
  315. 305 val_305
  316. 306 val_306
  317. 307 val_307
  318. 308 val_308
  319. 309 val_309
  320. 310 val_310
  321. 311 val_311
  322. 315 val_315
  323. 316 val_316
  324. 317 val_317
  325. 318 val_318
  326. 321 val_321
  327. 322 val_322
  328. 323 val_323
  329. 325 val_325
  330. 327 val_327
  331. 33 val_33
  332. 331 val_331
  333. 332 val_332
  334. 333 val_333
  335. 335 val_335
  336. 336 val_336
  337. 338 val_338
  338. 339 val_339
  339. 34 val_34
  340. 341 val_341
  341. 342 val_342
  342. 344 val_344
  343. 345 val_345
  344. 348 val_348
  345. 35 val_35
  346. 351 val_351
  347. 353 val_353
  348. 356 val_356
  349. 360 val_360
  350. 362 val_362
  351. 364 val_364
  352. 365 val_365
  353. 366 val_366
  354. 367 val_367
  355. 368 val_368
  356. 369 val_369
  357. 37 val_37
  358. 373 val_373
  359. 374 val_374
  360. 375 val_375
  361. 377 val_377
  362. 378 val_378
  363. 379 val_379
  364. 382 val_382
  365. 384 val_384
  366. 386 val_386
  367. 389 val_389
  368. 392 val_392
  369. 393 val_393
  370. 394 val_394
  371. 395 val_395
  372. 396 val_396
  373. 397 val_397
  374. 399 val_399
  375. 4 val_4
  376. 400 val_400
  377. 401 val_401
  378. 402 val_402
  379. 403 val_403
  380. 404 val_404
  381. 406 val_406
  382. 407 val_407
  383. 409 val_409
  384. 41 val_41
  385. 411 val_411
  386. 413 val_413
  387. 414 val_414
  388. 417 val_417
  389. 418 val_418
  390. 419 val_419
  391. 42 val_42
  392. 421 val_421
  393. 424 val_424
  394. 427 val_427
  395. 429 val_429
  396. 43 val_43
  397. 430 val_430
  398. 431 val_431
  399. 432 val_432
  400. 435 val_435
  401. 436 val_436
  402. 437 val_437
  403. 438 val_438
  404. 439 val_439
  405. 44 val_44
  406. 443 val_443
  407. 444 val_444
  408. 446 val_446
  409. 448 val_448
  410. 449 val_449
  411. 452 val_452
  412. 453 val_453
  413. 454 val_454
  414. 455 val_455
  415. 457 val_457
  416. 458 val_458
  417. 459 val_459
  418. 460 val_460
  419. 462 val_462
  420. 463 val_463
  421. 466 val_466
  422. 467 val_467
  423. 468 val_468
  424. 469 val_469
  425. 47 val_47
  426. 470 val_470
  427. 472 val_472
  428. 475 val_475
  429. 477 val_477
  430. 478 val_478
  431. 479 val_479
  432. 480 val_480
  433. 481 val_481
  434. 482 val_482
  435. 483 val_483
  436. 484 val_484
  437. 485 val_485
  438. 487 val_487
  439. 489 val_489
  440. 490 val_490
  441. 491 val_491
  442. 492 val_492
  443. 493 val_493
  444. 494 val_494
  445. 495 val_495
  446. 496 val_496
  447. 497 val_497
  448. 498 val_498
  449. 5 val_5
  450. 51 val_51
  451. 53 val_53
  452. 54 val_54
  453. 57 val_57
  454. 58 val_58
  455. 64 val_64
  456. 65 val_65
  457. 66 val_66
  458. 67 val_67
  459. 69 val_69
  460. 70 val_70
  461. 72 val_72
  462. 74 val_74
  463. 76 val_76
  464. 77 val_77
  465. 78 val_78
  466. 8 val_8
  467. 80 val_80
  468. 82 val_82
  469. 83 val_83
  470. 84 val_84
  471. 85 val_85
  472. 86 val_86
  473. 87 val_87
  474. 9 val_9
  475. 90 val_90
  476. 92 val_92
  477. 95 val_95
  478. 96 val_96
  479. 97 val_97
  480. 98 val_98
  481. PREHOOK: query: EXPLAIN SELECT key FROM src GROUP BY key HAVING max(value) > "val_255"
  482. PREHOOK: type: QUERY
  483. POSTHOOK: query: EXPLAIN SELECT key FROM src GROUP BY key HAVING max(value) > "val_255"
  484. POSTHOOK: type: QUERY
  485. ABSTRACT SYNTAX TREE:
  486. (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_GROUPBY (TOK_TABLE_OR_COL key)) (TOK_HAVING (> (TOK_FUNCTION max (TOK_TABLE_OR_COL value)) "val_255"))))
  487. STAGE DEPENDENCIES:
  488. Stage-1 is a root stage
  489. Stage-0 is a root stage
  490. STAGE PLANS:
  491. Stage: Stage-1
  492. Map Reduce
  493. Alias -> Map Operator Tree:
  494. src
  495. TableScan
  496. alias: src
  497. Select Operator
  498. expressions:
  499. expr: key
  500. type: string
  501. expr: value
  502. type: string
  503. outputColumnNames: key, value
  504. Group By Operator
  505. aggregations:
  506. expr: max(value)
  507. bucketGroup: false
  508. keys:
  509. expr: key
  510. type: string
  511. mode: hash
  512. outputColumnNames: _col0, _col1
  513. Reduce Output Operator
  514. key expressions:
  515. expr: _col0
  516. type: string
  517. sort order: +
  518. Map-reduce partition columns:
  519. expr: _col0
  520. type: string
  521. tag: -1
  522. value expressions:
  523. expr: _col1
  524. type: string
  525. Reduce Operator Tree:
  526. Group By Operator
  527. aggregations:
  528. expr: max(VALUE._col0)
  529. bucketGroup: false
  530. keys:
  531. expr: KEY._col0
  532. type: string
  533. mode: mergepartial
  534. outputColumnNames: _col0, _col1
  535. Filter Operator
  536. predicate:
  537. expr: (_col1 > 'val_255')
  538. type: boolean
  539. Select Operator
  540. expressions:
  541. expr: _col0
  542. type: string
  543. outputColumnNames: _col0
  544. File Output Operator
  545. compressed: false
  546. GlobalTableId: 0
  547. table:
  548. input format: org.apache.hadoop.mapred.TextInputFormat
  549. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  550. Stage: Stage-0
  551. Fetch Operator
  552. limit: -1
  553. PREHOOK: query: SELECT key FROM src GROUP BY key HAVING max(value) > "val_255"
  554. PREHOOK: type: QUERY
  555. PREHOOK: Input: default@src
  556. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-55-32_510_2871147486749455087/-mr-10000
  557. POSTHOOK: query: SELECT key FROM src GROUP BY key HAVING max(value) > "val_255"
  558. POSTHOOK: type: QUERY
  559. POSTHOOK: Input: default@src
  560. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-55-32_510_2871147486749455087/-mr-10000
  561. 256
  562. 257
  563. 258
  564. 26
  565. 260
  566. 262
  567. 263
  568. 265
  569. 266
  570. 27
  571. 272
  572. 273
  573. 274
  574. 275
  575. 277
  576. 278
  577. 28
  578. 280
  579. 281
  580. 282
  581. 283
  582. 284
  583. 285
  584. 286
  585. 287
  586. 288
  587. 289
  588. 291
  589. 292
  590. 296
  591. 298
  592. 30
  593. 302
  594. 305
  595. 306
  596. 307
  597. 308
  598. 309
  599. 310
  600. 311
  601. 315
  602. 316
  603. 317
  604. 318
  605. 321
  606. 322
  607. 323
  608. 325
  609. 327
  610. 33
  611. 331
  612. 332
  613. 333
  614. 335
  615. 336
  616. 338
  617. 339
  618. 34
  619. 341
  620. 342
  621. 344
  622. 345
  623. 348
  624. 35
  625. 351
  626. 353
  627. 356
  628. 360
  629. 362
  630. 364
  631. 365
  632. 366
  633. 367
  634. 368
  635. 369
  636. 37
  637. 373
  638. 374
  639. 375
  640. 377
  641. 378
  642. 379
  643. 382
  644. 384
  645. 386
  646. 389
  647. 392
  648. 393
  649. 394
  650. 395
  651. 396
  652. 397
  653. 399
  654. 4
  655. 400
  656. 401
  657. 402
  658. 403
  659. 404
  660. 406
  661. 407
  662. 409
  663. 41
  664. 411
  665. 413
  666. 414
  667. 417
  668. 418
  669. 419
  670. 42
  671. 421
  672. 424
  673. 427
  674. 429
  675. 43
  676. 430
  677. 431
  678. 432
  679. 435
  680. 436
  681. 437
  682. 438
  683. 439
  684. 44
  685. 443
  686. 444
  687. 446
  688. 448
  689. 449
  690. 452
  691. 453
  692. 454
  693. 455
  694. 457
  695. 458
  696. 459
  697. 460
  698. 462
  699. 463
  700. 466
  701. 467
  702. 468
  703. 469
  704. 47
  705. 470
  706. 472
  707. 475
  708. 477
  709. 478
  710. 479
  711. 480
  712. 481
  713. 482
  714. 483
  715. 484
  716. 485
  717. 487
  718. 489
  719. 490
  720. 491
  721. 492
  722. 493
  723. 494
  724. 495
  725. 496
  726. 497
  727. 498
  728. 5
  729. 51
  730. 53
  731. 54
  732. 57
  733. 58
  734. 64
  735. 65
  736. 66
  737. 67
  738. 69
  739. 70
  740. 72
  741. 74
  742. 76
  743. 77
  744. 78
  745. 8
  746. 80
  747. 82
  748. 83
  749. 84
  750. 85
  751. 86
  752. 87
  753. 9
  754. 90
  755. 92
  756. 95
  757. 96
  758. 97
  759. 98
  760. PREHOOK: query: EXPLAIN SELECT key FROM src where key > 300 GROUP BY key HAVING max(value) > "val_255"
  761. PREHOOK: type: QUERY
  762. POSTHOOK: query: EXPLAIN SELECT key FROM src where key > 300 GROUP BY key HAVING max(value) > "val_255"
  763. POSTHOOK: type: QUERY
  764. ABSTRACT SYNTAX TREE:
  765. (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_WHERE (> (TOK_TABLE_OR_COL key) 300)) (TOK_GROUPBY (TOK_TABLE_OR_COL key)) (TOK_HAVING (> (TOK_FUNCTION max (TOK_TABLE_OR_COL value)) "val_255"))))
  766. STAGE DEPENDENCIES:
  767. Stage-1 is a root stage
  768. Stage-0 is a root stage
  769. STAGE PLANS:
  770. Stage: Stage-1
  771. Map Reduce
  772. Alias -> Map Operator Tree:
  773. src
  774. TableScan
  775. alias: src
  776. Filter Operator
  777. predicate:
  778. expr: (key > 300)
  779. type: boolean
  780. Select Operator
  781. expressions:
  782. expr: key
  783. type: string
  784. expr: value
  785. type: string
  786. outputColumnNames: key, value
  787. Group By Operator
  788. aggregations:
  789. expr: max(value)
  790. bucketGroup: false
  791. keys:
  792. expr: key
  793. type: string
  794. mode: hash
  795. outputColumnNames: _col0, _col1
  796. Reduce Output Operator
  797. key expressions:
  798. expr: _col0
  799. type: string
  800. sort order: +
  801. Map-reduce partition columns:
  802. expr: _col0
  803. type: string
  804. tag: -1
  805. value expressions:
  806. expr: _col1
  807. type: string
  808. Reduce Operator Tree:
  809. Group By Operator
  810. aggregations:
  811. expr: max(VALUE._col0)
  812. bucketGroup: false
  813. keys:
  814. expr: KEY._col0
  815. type: string
  816. mode: mergepartial
  817. outputColumnNames: _col0, _col1
  818. Filter Operator
  819. predicate:
  820. expr: (_col1 > 'val_255')
  821. type: boolean
  822. Select Operator
  823. expressions:
  824. expr: _col0
  825. type: string
  826. outputColumnNames: _col0
  827. File Output Operator
  828. compressed: false
  829. GlobalTableId: 0
  830. table:
  831. input format: org.apache.hadoop.mapred.TextInputFormat
  832. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  833. Stage: Stage-0
  834. Fetch Operator
  835. limit: -1
  836. PREHOOK: query: SELECT key FROM src where key > 300 GROUP BY key HAVING max(value) > "val_255"
  837. PREHOOK: type: QUERY
  838. PREHOOK: Input: default@src
  839. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-55-36_115_3214302557613052494/-mr-10000
  840. POSTHOOK: query: SELECT key FROM src where key > 300 GROUP BY key HAVING max(value) > "val_255"
  841. POSTHOOK: type: QUERY
  842. POSTHOOK: Input: default@src
  843. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-55-36_115_3214302557613052494/-mr-10000
  844. 302
  845. 305
  846. 306
  847. 307
  848. 308
  849. 309
  850. 310
  851. 311
  852. 315
  853. 316
  854. 317
  855. 318
  856. 321
  857. 322
  858. 323
  859. 325
  860. 327
  861. 331
  862. 332
  863. 333
  864. 335
  865. 336
  866. 338
  867. 339
  868. 341
  869. 342
  870. 344
  871. 345
  872. 348
  873. 351
  874. 353
  875. 356
  876. 360
  877. 362
  878. 364
  879. 365
  880. 366
  881. 367
  882. 368
  883. 369
  884. 373
  885. 374
  886. 375
  887. 377
  888. 378
  889. 379
  890. 382
  891. 384
  892. 386
  893. 389
  894. 392
  895. 393
  896. 394
  897. 395
  898. 396
  899. 397
  900. 399
  901. 400
  902. 401
  903. 402
  904. 403
  905. 404
  906. 406
  907. 407
  908. 409
  909. 411
  910. 413
  911. 414
  912. 417
  913. 418
  914. 419
  915. 421
  916. 424
  917. 427
  918. 429
  919. 430
  920. 431
  921. 432
  922. 435
  923. 436
  924. 437
  925. 438
  926. 439
  927. 443
  928. 444
  929. 446
  930. 448
  931. 449
  932. 452
  933. 453
  934. 454
  935. 455
  936. 457
  937. 458
  938. 459
  939. 460
  940. 462
  941. 463
  942. 466
  943. 467
  944. 468
  945. 469
  946. 470
  947. 472
  948. 475
  949. 477
  950. 478
  951. 479
  952. 480
  953. 481
  954. 482
  955. 483
  956. 484
  957. 485
  958. 487
  959. 489
  960. 490
  961. 491
  962. 492
  963. 493
  964. 494
  965. 495
  966. 496
  967. 497
  968. 498
  969. PREHOOK: query: EXPLAIN SELECT key, max(value) FROM src GROUP BY key HAVING max(value) > "val_255"
  970. PREHOOK: type: QUERY
  971. POSTHOOK: query: EXPLAIN SELECT key, max(value) FROM src GROUP BY key HAVING max(value) > "val_255"
  972. POSTHOOK: type: QUERY
  973. ABSTRACT SYNTAX TREE:
  974. (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_SELEXPR (TOK_FUNCTION max (TOK_TABLE_OR_COL value)))) (TOK_GROUPBY (TOK_TABLE_OR_COL key)) (TOK_HAVING (> (TOK_FUNCTION max (TOK_TABLE_OR_COL value)) "val_255"))))
  975. STAGE DEPENDENCIES:
  976. Stage-1 is a root stage
  977. Stage-0 is a root stage
  978. STAGE PLANS:
  979. Stage: Stage-1
  980. Map Reduce
  981. Alias -> Map Operator Tree:
  982. src
  983. TableScan
  984. alias: src
  985. Select Operator
  986. expressions:
  987. expr: key
  988. type: string
  989. expr: value
  990. type: string
  991. outputColumnNames: key, value
  992. Group By Operator
  993. aggregations:
  994. expr: max(value)
  995. bucketGroup: false
  996. keys:
  997. expr: key
  998. type: string
  999. mode: hash
  1000. outputColumnNames: _col0, _col1
  1001. Reduce Output Operator
  1002. key expressions:
  1003. expr: _col0
  1004. type: string
  1005. sort order: +
  1006. Map-reduce partition columns:
  1007. expr: _col0
  1008. type: string
  1009. tag: -1
  1010. value expressions:
  1011. expr: _col1
  1012. type: string
  1013. Reduce Operator Tree:
  1014. Group By Operator
  1015. aggregations:
  1016. expr: max(VALUE._col0)
  1017. bucketGroup: false
  1018. keys:
  1019. expr: KEY._col0
  1020. type: string
  1021. mode: mergepartial
  1022. outputColumnNames: _col0, _col1
  1023. Filter Operator
  1024. predicate:
  1025. expr: (_col1 > 'val_255')
  1026. type: boolean
  1027. Select Operator
  1028. expressions:
  1029. expr: _col0
  1030. type: string
  1031. expr: _col1
  1032. type: string
  1033. outputColumnNames: _col0, _col1
  1034. File Output Operator
  1035. compressed: false
  1036. GlobalTableId: 0
  1037. table:
  1038. input format: org.apache.hadoop.mapred.TextInputFormat
  1039. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  1040. Stage: Stage-0
  1041. Fetch Operator
  1042. limit: -1
  1043. PREHOOK: query: SELECT key, max(value) FROM src GROUP BY key HAVING max(value) > "val_255"
  1044. PREHOOK: type: QUERY
  1045. PREHOOK: Input: default@src
  1046. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-55-39_727_9028145327249190888/-mr-10000
  1047. POSTHOOK: query: SELECT key, max(value) FROM src GROUP BY key HAVING max(value) > "val_255"
  1048. POSTHOOK: type: QUERY
  1049. POSTHOOK: Input: default@src
  1050. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-55-39_727_9028145327249190888/-mr-10000
  1051. 256 val_256
  1052. 257 val_257
  1053. 258 val_258
  1054. 26 val_26
  1055. 260 val_260
  1056. 262 val_262
  1057. 263 val_263
  1058. 265 val_265
  1059. 266 val_266
  1060. 27 val_27
  1061. 272 val_272
  1062. 273 val_273
  1063. 274 val_274
  1064. 275 val_275
  1065. 277 val_277
  1066. 278 val_278
  1067. 28 val_28
  1068. 280 val_280
  1069. 281 val_281
  1070. 282 val_282
  1071. 283 val_283
  1072. 284 val_284
  1073. 285 val_285
  1074. 286 val_286
  1075. 287 val_287
  1076. 288 val_288
  1077. 289 val_289
  1078. 291 val_291
  1079. 292 val_292
  1080. 296 val_296
  1081. 298 val_298
  1082. 30 val_30
  1083. 302 val_302
  1084. 305 val_305
  1085. 306 val_306
  1086. 307 val_307
  1087. 308 val_308
  1088. 309 val_309
  1089. 310 val_310
  1090. 311 val_311
  1091. 315 val_315
  1092. 316 val_316
  1093. 317 val_317
  1094. 318 val_318
  1095. 321 val_321
  1096. 322 val_322
  1097. 323 val_323
  1098. 325 val_325
  1099. 327 val_327
  1100. 33 val_33
  1101. 331 val_331
  1102. 332 val_332
  1103. 333 val_333
  1104. 335 val_335
  1105. 336 val_336
  1106. 338 val_338
  1107. 339 val_339
  1108. 34 val_34
  1109. 341 val_341
  1110. 342 val_342
  1111. 344 val_344
  1112. 345 val_345
  1113. 348 val_348
  1114. 35 val_35
  1115. 351 val_351
  1116. 353 val_353
  1117. 356 val_356
  1118. 360 val_360
  1119. 362 val_362
  1120. 364 val_364
  1121. 365 val_365
  1122. 366 val_366
  1123. 367 val_367
  1124. 368 val_368
  1125. 369 val_369
  1126. 37 val_37
  1127. 373 val_373
  1128. 374 val_374
  1129. 375 val_375
  1130. 377 val_377
  1131. 378 val_378
  1132. 379 val_379
  1133. 382 val_382
  1134. 384 val_384
  1135. 386 val_386
  1136. 389 val_389
  1137. 392 val_392
  1138. 393 val_393
  1139. 394 val_394
  1140. 395 val_395
  1141. 396 val_396
  1142. 397 val_397
  1143. 399 val_399
  1144. 4 val_4
  1145. 400 val_400
  1146. 401 val_401
  1147. 402 val_402
  1148. 403 val_403
  1149. 404 val_404
  1150. 406 val_406
  1151. 407 val_407
  1152. 409 val_409
  1153. 41 val_41
  1154. 411 val_411
  1155. 413 val_413
  1156. 414 val_414
  1157. 417 val_417
  1158. 418 val_418
  1159. 419 val_419
  1160. 42 val_42
  1161. 421 val_421
  1162. 424 val_424
  1163. 427 val_427
  1164. 429 val_429
  1165. 43 val_43
  1166. 430 val_430
  1167. 431 val_431
  1168. 432 val_432
  1169. 435 val_435
  1170. 436 val_436
  1171. 437 val_437
  1172. 438 val_438
  1173. 439 val_439
  1174. 44 val_44
  1175. 443 val_443
  1176. 444 val_444
  1177. 446 val_446
  1178. 448 val_448
  1179. 449 val_449
  1180. 452 val_452
  1181. 453 val_453
  1182. 454 val_454
  1183. 455 val_455
  1184. 457 val_457
  1185. 458 val_458
  1186. 459 val_459
  1187. 460 val_460
  1188. 462 val_462
  1189. 463 val_463
  1190. 466 val_466
  1191. 467 val_467
  1192. 468 val_468
  1193. 469 val_469
  1194. 47 val_47
  1195. 470 val_470
  1196. 472 val_472
  1197. 475 val_475
  1198. 477 val_477
  1199. 478 val_478
  1200. 479 val_479
  1201. 480 val_480
  1202. 481 val_481
  1203. 482 val_482
  1204. 483 val_483
  1205. 484 val_484
  1206. 485 val_485
  1207. 487 val_487
  1208. 489 val_489
  1209. 490 val_490
  1210. 491 val_491
  1211. 492 val_492
  1212. 493 val_493
  1213. 494 val_494
  1214. 495 val_495
  1215. 496 val_496
  1216. 497 val_497
  1217. 498 val_498
  1218. 5 val_5
  1219. 51 val_51
  1220. 53 val_53
  1221. 54 val_54
  1222. 57 val_57
  1223. 58 val_58
  1224. 64 val_64
  1225. 65 val_65
  1226. 66 val_66
  1227. 67 val_67
  1228. 69 val_69
  1229. 70 val_70
  1230. 72 val_72
  1231. 74 val_74
  1232. 76 val_76
  1233. 77 val_77
  1234. 78 val_78
  1235. 8 val_8
  1236. 80 val_80
  1237. 82 val_82
  1238. 83 val_83
  1239. 84 val_84
  1240. 85 val_85
  1241. 86 val_86
  1242. 87 val_87
  1243. 9 val_9
  1244. 90 val_90
  1245. 92 val_92
  1246. 95 val_95
  1247. 96 val_96
  1248. 97 val_97
  1249. 98 val_98