PageRenderTime 46ms CodeModel.GetById 18ms 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
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. MAP src.key, src.key
  10. USING 'cat'
  11. DISTRIBUTE BY key
  12. SORT BY key, value
  13. ) tmap
  14. INSERT OVERWRITE TABLE dest1
  15. REDUCE tmap.key, tmap.value
  16. USING 'input20_script'
  17. AS (key STRING, value STRING)
  18. PREHOOK: type: QUERY
  19. POSTHOOK: query: EXPLAIN
  20. FROM (
  21. FROM src
  22. MAP src.key, src.key
  23. USING 'cat'
  24. DISTRIBUTE BY key
  25. SORT BY key, value
  26. ) tmap
  27. INSERT OVERWRITE TABLE dest1
  28. REDUCE tmap.key, tmap.value
  29. USING 'input20_script'
  30. AS (key STRING, value STRING)
  31. POSTHOOK: type: QUERY
  32. ABSTRACT 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. STAGE DEPENDENCIES:
  35. Stage-1 is a root stage
  36. Stage-0 depends on stages: Stage-1
  37. Stage-2 depends on stages: Stage-0
  38. STAGE PLANS:
  39. Stage: Stage-1
  40. Map Reduce
  41. Alias -> Map Operator Tree:
  42. tmap:src
  43. TableScan
  44. alias: src
  45. Select Operator
  46. expressions:
  47. expr: key
  48. type: string
  49. expr: key
  50. type: string
  51. outputColumnNames: _col0, _col1
  52. Transform Operator
  53. command: cat
  54. output info:
  55. input format: org.apache.hadoop.mapred.TextInputFormat
  56. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  57. Reduce Output Operator
  58. key expressions:
  59. expr: _col0
  60. type: string
  61. expr: _col1
  62. type: string
  63. sort order: ++
  64. Map-reduce partition columns:
  65. expr: _col0
  66. type: string
  67. tag: -1
  68. value expressions:
  69. expr: _col0
  70. type: string
  71. expr: _col1
  72. type: string
  73. Reduce Operator Tree:
  74. Extract
  75. Select Operator
  76. expressions:
  77. expr: _col0
  78. type: string
  79. expr: _col1
  80. type: string
  81. outputColumnNames: _col0, _col1
  82. Transform Operator
  83. command: input20_script
  84. output info:
  85. input format: org.apache.hadoop.mapred.TextInputFormat
  86. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  87. Select Operator
  88. expressions:
  89. expr: UDFToInteger(_col0)
  90. type: int
  91. expr: _col1
  92. type: string
  93. outputColumnNames: _col0, _col1
  94. File Output Operator
  95. compressed: false
  96. GlobalTableId: 1
  97. table:
  98. input format: org.apache.hadoop.mapred.TextInputFormat
  99. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  100. serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  101. name: default.dest1
  102. Stage: Stage-0
  103. Move Operator
  104. tables:
  105. replace: true
  106. table:
  107. input format: org.apache.hadoop.mapred.TextInputFormat
  108. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  109. serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  110. name: default.dest1
  111. Stage: Stage-2
  112. Stats-Aggr Operator
  113. PREHOOK: query: FROM (
  114. FROM src
  115. MAP src.key, src.key
  116. USING 'cat'
  117. DISTRIBUTE BY key
  118. SORT BY key, value
  119. ) tmap
  120. INSERT OVERWRITE TABLE dest1
  121. REDUCE tmap.key, tmap.value
  122. USING 'input20_script'
  123. AS (key STRING, value STRING)
  124. PREHOOK: type: QUERY
  125. PREHOOK: Input: default@src
  126. PREHOOK: Output: default@dest1
  127. POSTHOOK: query: FROM (
  128. FROM src
  129. MAP src.key, src.key
  130. USING 'cat'
  131. DISTRIBUTE BY key
  132. SORT BY key, value
  133. ) tmap
  134. INSERT OVERWRITE TABLE dest1
  135. REDUCE tmap.key, tmap.value
  136. USING 'input20_script'
  137. AS (key STRING, value STRING)
  138. POSTHOOK: type: QUERY
  139. POSTHOOK: Input: default@src
  140. POSTHOOK: Output: default@dest1
  141. POSTHOOK: Lineage: dest1.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  142. POSTHOOK: Lineage: dest1.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  143. PREHOOK: query: SELECT * FROM dest1 SORT BY key, value
  144. PREHOOK: type: QUERY
  145. PREHOOK: Input: default@dest1
  146. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-55-32_693_8757115489547146865/-mr-10000
  147. POSTHOOK: query: SELECT * FROM dest1 SORT BY key, value
  148. POSTHOOK: type: QUERY
  149. POSTHOOK: Input: default@dest1
  150. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_15-55-32_693_8757115489547146865/-mr-10000
  151. POSTHOOK: Lineage: dest1.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  152. POSTHOOK: Lineage: dest1.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  153. 1 105_105
  154. 1 10_10
  155. 1 111_111
  156. 1 114_114
  157. 1 116_116
  158. 1 11_11
  159. 1 126_126
  160. 1 131_131
  161. 1 133_133
  162. 1 136_136
  163. 1 143_143
  164. 1 145_145
  165. 1 150_150
  166. 1 153_153
  167. 1 155_155
  168. 1 156_156
  169. 1 157_157
  170. 1 158_158
  171. 1 160_160
  172. 1 162_162
  173. 1 163_163
  174. 1 166_166
  175. 1 168_168
  176. 1 170_170
  177. 1 177_177
  178. 1 178_178
  179. 1 17_17
  180. 1 180_180
  181. 1 181_181
  182. 1 183_183
  183. 1 186_186
  184. 1 189_189
  185. 1 190_190
  186. 1 192_192
  187. 1 194_194
  188. 1 196_196
  189. 1 19_19
  190. 1 201_201
  191. 1 202_202
  192. 1 20_20
  193. 1 214_214
  194. 1 218_218
  195. 1 222_222
  196. 1 226_226
  197. 1 228_228
  198. 1 235_235
  199. 1 241_241
  200. 1 244_244
  201. 1 247_247
  202. 1 248_248
  203. 1 249_249
  204. 1 252_252
  205. 1 257_257
  206. 1 258_258
  207. 1 260_260
  208. 1 262_262
  209. 1 263_263
  210. 1 266_266
  211. 1 274_274
  212. 1 275_275
  213. 1 27_27
  214. 1 283_283
  215. 1 284_284
  216. 1 285_285
  217. 1 286_286
  218. 1 287_287
  219. 1 289_289
  220. 1 28_28
  221. 1 291_291
  222. 1 292_292
  223. 1 296_296
  224. 1 2_2
  225. 1 302_302
  226. 1 305_305
  227. 1 306_306
  228. 1 308_308
  229. 1 30_30
  230. 1 310_310
  231. 1 315_315
  232. 1 323_323
  233. 1 332_332
  234. 1 335_335
  235. 1 336_336
  236. 1 338_338
  237. 1 339_339
  238. 1 33_33
  239. 1 341_341
  240. 1 345_345
  241. 1 34_34
  242. 1 351_351
  243. 1 356_356
  244. 1 360_360
  245. 1 362_362
  246. 1 364_364
  247. 1 365_365
  248. 1 366_366
  249. 1 368_368
  250. 1 373_373
  251. 1 374_374
  252. 1 375_375
  253. 1 377_377
  254. 1 378_378
  255. 1 379_379
  256. 1 386_386
  257. 1 389_389
  258. 1 392_392
  259. 1 393_393
  260. 1 394_394
  261. 1 400_400
  262. 1 402_402
  263. 1 407_407
  264. 1 411_411
  265. 1 418_418
  266. 1 419_419
  267. 1 41_41
  268. 1 421_421
  269. 1 427_427
  270. 1 432_432
  271. 1 435_435
  272. 1 436_436
  273. 1 437_437
  274. 1 43_43
  275. 1 443_443
  276. 1 444_444
  277. 1 446_446
  278. 1 448_448
  279. 1 449_449
  280. 1 44_44
  281. 1 452_452
  282. 1 453_453
  283. 1 455_455
  284. 1 457_457
  285. 1 460_460
  286. 1 467_467
  287. 1 470_470
  288. 1 472_472
  289. 1 475_475
  290. 1 477_477
  291. 1 479_479
  292. 1 47_47
  293. 1 481_481
  294. 1 482_482
  295. 1 483_483
  296. 1 484_484
  297. 1 485_485
  298. 1 487_487
  299. 1 490_490
  300. 1 491_491
  301. 1 493_493
  302. 1 494_494
  303. 1 495_495
  304. 1 496_496
  305. 1 497_497
  306. 1 4_4
  307. 1 53_53
  308. 1 54_54
  309. 1 57_57
  310. 1 64_64
  311. 1 65_65
  312. 1 66_66
  313. 1 69_69
  314. 1 74_74
  315. 1 77_77
  316. 1 78_78
  317. 1 80_80
  318. 1 82_82
  319. 1 85_85
  320. 1 86_86
  321. 1 87_87
  322. 1 8_8
  323. 1 92_92
  324. 1 96_96
  325. 1 9_9
  326. 2 100_100
  327. 2 103_103
  328. 2 104_104
  329. 2 113_113
  330. 2 118_118
  331. 2 120_120
  332. 2 125_125
  333. 2 129_129
  334. 2 12_12
  335. 2 134_134
  336. 2 137_137
  337. 2 146_146
  338. 2 149_149
  339. 2 152_152
  340. 2 15_15
  341. 2 164_164
  342. 2 165_165
  343. 2 172_172
  344. 2 174_174
  345. 2 175_175
  346. 2 176_176
  347. 2 179_179
  348. 2 18_18
  349. 2 191_191
  350. 2 195_195
  351. 2 197_197
  352. 2 200_200
  353. 2 203_203
  354. 2 205_205
  355. 2 207_207
  356. 2 209_209
  357. 2 213_213
  358. 2 216_216
  359. 2 217_217
  360. 2 219_219
  361. 2 221_221
  362. 2 223_223
  363. 2 224_224
  364. 2 229_229
  365. 2 233_233
  366. 2 237_237
  367. 2 238_238
  368. 2 239_239
  369. 2 242_242
  370. 2 24_24
  371. 2 255_255
  372. 2 256_256
  373. 2 265_265
  374. 2 26_26
  375. 2 272_272
  376. 2 278_278
  377. 2 280_280
  378. 2 281_281
  379. 2 282_282
  380. 2 288_288
  381. 2 307_307
  382. 2 309_309
  383. 2 317_317
  384. 2 321_321
  385. 2 322_322
  386. 2 325_325
  387. 2 331_331
  388. 2 333_333
  389. 2 342_342
  390. 2 344_344
  391. 2 353_353
  392. 2 367_367
  393. 2 37_37
  394. 2 382_382
  395. 2 395_395
  396. 2 397_397
  397. 2 399_399
  398. 2 404_404
  399. 2 413_413
  400. 2 414_414
  401. 2 424_424
  402. 2 429_429
  403. 2 42_42
  404. 2 439_439
  405. 2 458_458
  406. 2 459_459
  407. 2 462_462
  408. 2 463_463
  409. 2 478_478
  410. 2 492_492
  411. 2 51_51
  412. 2 58_58
  413. 2 67_67
  414. 2 72_72
  415. 2 76_76
  416. 2 83_83
  417. 2 84_84
  418. 2 95_95
  419. 2 97_97
  420. 2 98_98
  421. 3 0_0
  422. 3 119_119
  423. 3 128_128
  424. 3 167_167
  425. 3 187_187
  426. 3 193_193
  427. 3 199_199
  428. 3 208_208
  429. 3 273_273
  430. 3 298_298
  431. 3 311_311
  432. 3 316_316
  433. 3 318_318
  434. 3 327_327
  435. 3 35_35
  436. 3 369_369
  437. 3 384_384
  438. 3 396_396
  439. 3 403_403
  440. 3 409_409
  441. 3 417_417
  442. 3 430_430
  443. 3 431_431
  444. 3 438_438
  445. 3 454_454
  446. 3 466_466
  447. 3 480_480
  448. 3 498_498
  449. 3 5_5
  450. 3 70_70
  451. 3 90_90
  452. 4 138_138
  453. 4 169_169
  454. 4 277_277
  455. 4 406_406
  456. 4 468_468
  457. 4 489_489
  458. 5 230_230
  459. 5 348_348
  460. 5 401_401
  461. 5 469_469