PageRenderTime 44ms CodeModel.GetById 20ms RepoModel.GetById 0ms app.codeStats 0ms

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

#
text | 516 lines | 506 code | 10 blank | 0 comment | 0 complexity | 2e77d14ffa101c007371d35957c4ba84 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
  1. PREHOOK: query: CREATE TABLE tmp1(key INT, cnt INT)
  2. PREHOOK: type: CREATETABLE
  3. POSTHOOK: query: CREATE TABLE tmp1(key INT, cnt INT)
  4. POSTHOOK: type: CREATETABLE
  5. POSTHOOK: Output: default@tmp1
  6. PREHOOK: query: CREATE TABLE tmp2(key INT, cnt INT)
  7. PREHOOK: type: CREATETABLE
  8. POSTHOOK: query: CREATE TABLE tmp2(key INT, cnt INT)
  9. POSTHOOK: type: CREATETABLE
  10. POSTHOOK: Output: default@tmp2
  11. PREHOOK: query: CREATE TABLE dest_j1(key INT, value INT, val2 INT)
  12. PREHOOK: type: CREATETABLE
  13. POSTHOOK: query: CREATE TABLE dest_j1(key INT, value INT, val2 INT)
  14. POSTHOOK: type: CREATETABLE
  15. POSTHOOK: Output: default@dest_j1
  16. PREHOOK: query: INSERT OVERWRITE TABLE tmp1
  17. SELECT key, count(1) from src group by key
  18. PREHOOK: type: QUERY
  19. PREHOOK: Input: default@src
  20. PREHOOK: Output: default@tmp1
  21. POSTHOOK: query: INSERT OVERWRITE TABLE tmp1
  22. SELECT key, count(1) from src group by key
  23. POSTHOOK: type: QUERY
  24. POSTHOOK: Input: default@src
  25. POSTHOOK: Output: default@tmp1
  26. POSTHOOK: Lineage: tmp1.cnt EXPRESSION [(src)src.null, ]
  27. POSTHOOK: Lineage: tmp1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  28. PREHOOK: query: INSERT OVERWRITE TABLE tmp2
  29. SELECT key, count(1) from src group by key
  30. PREHOOK: type: QUERY
  31. PREHOOK: Input: default@src
  32. PREHOOK: Output: default@tmp2
  33. POSTHOOK: query: INSERT OVERWRITE TABLE tmp2
  34. SELECT key, count(1) from src group by key
  35. POSTHOOK: type: QUERY
  36. POSTHOOK: Input: default@src
  37. POSTHOOK: Output: default@tmp2
  38. POSTHOOK: Lineage: tmp1.cnt EXPRESSION [(src)src.null, ]
  39. POSTHOOK: Lineage: tmp1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  40. POSTHOOK: Lineage: tmp2.cnt EXPRESSION [(src)src.null, ]
  41. POSTHOOK: Lineage: tmp2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  42. PREHOOK: query: EXPLAIN
  43. INSERT OVERWRITE TABLE dest_j1
  44. SELECT /*+ MAPJOIN(x) */ x.key, x.cnt, y.cnt
  45. FROM tmp1 x JOIN tmp2 y ON (x.key = y.key)
  46. PREHOOK: type: QUERY
  47. POSTHOOK: query: EXPLAIN
  48. INSERT OVERWRITE TABLE dest_j1
  49. SELECT /*+ MAPJOIN(x) */ x.key, x.cnt, y.cnt
  50. FROM tmp1 x JOIN tmp2 y ON (x.key = y.key)
  51. POSTHOOK: type: QUERY
  52. POSTHOOK: Lineage: tmp1.cnt EXPRESSION [(src)src.null, ]
  53. POSTHOOK: Lineage: tmp1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  54. POSTHOOK: Lineage: tmp2.cnt EXPRESSION [(src)src.null, ]
  55. POSTHOOK: Lineage: tmp2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  56. ABSTRACT SYNTAX TREE:
  57. (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME tmp1) x) (TOK_TABREF (TOK_TABNAME tmp2) y) (= (. (TOK_TABLE_OR_COL x) key) (. (TOK_TABLE_OR_COL y) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest_j1))) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST x))) (TOK_SELEXPR (. (TOK_TABLE_OR_COL x) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL x) cnt)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL y) cnt)))))
  58. STAGE DEPENDENCIES:
  59. Stage-7 is a root stage
  60. Stage-1 depends on stages: Stage-7
  61. Stage-5 depends on stages: Stage-1 , consists of Stage-4, Stage-3
  62. Stage-4
  63. Stage-0 depends on stages: Stage-4, Stage-3
  64. Stage-2 depends on stages: Stage-0
  65. Stage-3
  66. STAGE PLANS:
  67. Stage: Stage-7
  68. Map Reduce Local Work
  69. Alias -> Map Local Tables:
  70. x
  71. Fetch Operator
  72. limit: -1
  73. Alias -> Map Local Operator Tree:
  74. x
  75. TableScan
  76. alias: x
  77. HashTable Sink Operator
  78. condition expressions:
  79. 0 {key} {cnt}
  80. 1 {cnt}
  81. handleSkewJoin: false
  82. keys:
  83. 0 [Column[key]]
  84. 1 [Column[key]]
  85. Position of Big Table: 1
  86. Stage: Stage-1
  87. Map Reduce
  88. Alias -> Map Operator Tree:
  89. y
  90. TableScan
  91. alias: y
  92. Map Join Operator
  93. condition map:
  94. Inner Join 0 to 1
  95. condition expressions:
  96. 0 {key} {cnt}
  97. 1 {cnt}
  98. handleSkewJoin: false
  99. keys:
  100. 0 [Column[key]]
  101. 1 [Column[key]]
  102. outputColumnNames: _col0, _col1, _col5
  103. Position of Big Table: 1
  104. Select Operator
  105. expressions:
  106. expr: _col0
  107. type: int
  108. expr: _col1
  109. type: int
  110. expr: _col5
  111. type: int
  112. outputColumnNames: _col0, _col1, _col5
  113. Select Operator
  114. expressions:
  115. expr: _col0
  116. type: int
  117. expr: _col1
  118. type: int
  119. expr: _col5
  120. type: int
  121. outputColumnNames: _col0, _col1, _col2
  122. File Output Operator
  123. compressed: false
  124. GlobalTableId: 1
  125. table:
  126. input format: org.apache.hadoop.mapred.TextInputFormat
  127. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  128. serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  129. name: default.dest_j1
  130. Local Work:
  131. Map Reduce Local Work
  132. Stage: Stage-5
  133. Conditional Operator
  134. Stage: Stage-4
  135. Move Operator
  136. files:
  137. hdfs directory: true
  138. destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-06-35_242_5756886415545600234/-ext-10000
  139. Stage: Stage-0
  140. Move Operator
  141. tables:
  142. replace: true
  143. table:
  144. input format: org.apache.hadoop.mapred.TextInputFormat
  145. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  146. serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  147. name: default.dest_j1
  148. Stage: Stage-2
  149. Stats-Aggr Operator
  150. Stage: Stage-3
  151. Map Reduce
  152. Alias -> Map Operator Tree:
  153. pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-06-35_242_5756886415545600234/-ext-10002
  154. File Output Operator
  155. compressed: false
  156. GlobalTableId: 0
  157. table:
  158. input format: org.apache.hadoop.mapred.TextInputFormat
  159. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  160. serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  161. name: default.dest_j1
  162. PREHOOK: query: INSERT OVERWRITE TABLE dest_j1
  163. SELECT /*+ MAPJOIN(x) */ x.key, x.cnt, y.cnt
  164. FROM tmp1 x JOIN tmp2 y ON (x.key = y.key)
  165. PREHOOK: type: QUERY
  166. PREHOOK: Input: default@tmp1
  167. PREHOOK: Input: default@tmp2
  168. PREHOOK: Output: default@dest_j1
  169. POSTHOOK: query: INSERT OVERWRITE TABLE dest_j1
  170. SELECT /*+ MAPJOIN(x) */ x.key, x.cnt, y.cnt
  171. FROM tmp1 x JOIN tmp2 y ON (x.key = y.key)
  172. POSTHOOK: type: QUERY
  173. POSTHOOK: Input: default@tmp1
  174. POSTHOOK: Input: default@tmp2
  175. POSTHOOK: Output: default@dest_j1
  176. POSTHOOK: Lineage: dest_j1.key SIMPLE [(tmp1)x.FieldSchema(name:key, type:int, comment:null), ]
  177. POSTHOOK: Lineage: dest_j1.val2 SIMPLE [(tmp2)y.FieldSchema(name:cnt, type:int, comment:null), ]
  178. POSTHOOK: Lineage: dest_j1.value SIMPLE [(tmp1)x.FieldSchema(name:cnt, type:int, comment:null), ]
  179. POSTHOOK: Lineage: tmp1.cnt EXPRESSION [(src)src.null, ]
  180. POSTHOOK: Lineage: tmp1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  181. POSTHOOK: Lineage: tmp2.cnt EXPRESSION [(src)src.null, ]
  182. POSTHOOK: Lineage: tmp2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  183. PREHOOK: query: select * from dest_j1 x order by x.key
  184. PREHOOK: type: QUERY
  185. PREHOOK: Input: default@dest_j1
  186. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-06-41_953_1173247532179912206/-mr-10000
  187. POSTHOOK: query: select * from dest_j1 x order by x.key
  188. POSTHOOK: type: QUERY
  189. POSTHOOK: Input: default@dest_j1
  190. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-06-41_953_1173247532179912206/-mr-10000
  191. POSTHOOK: Lineage: dest_j1.key SIMPLE [(tmp1)x.FieldSchema(name:key, type:int, comment:null), ]
  192. POSTHOOK: Lineage: dest_j1.val2 SIMPLE [(tmp2)y.FieldSchema(name:cnt, type:int, comment:null), ]
  193. POSTHOOK: Lineage: dest_j1.value SIMPLE [(tmp1)x.FieldSchema(name:cnt, type:int, comment:null), ]
  194. POSTHOOK: Lineage: tmp1.cnt EXPRESSION [(src)src.null, ]
  195. POSTHOOK: Lineage: tmp1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  196. POSTHOOK: Lineage: tmp2.cnt EXPRESSION [(src)src.null, ]
  197. POSTHOOK: Lineage: tmp2.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
  198. 0 3 3
  199. 2 1 1
  200. 4 1 1
  201. 5 3 3
  202. 8 1 1
  203. 9 1 1
  204. 10 1 1
  205. 11 1 1
  206. 12 2 2
  207. 15 2 2
  208. 17 1 1
  209. 18 2 2
  210. 19 1 1
  211. 20 1 1
  212. 24 2 2
  213. 26 2 2
  214. 27 1 1
  215. 28 1 1
  216. 30 1 1
  217. 33 1 1
  218. 34 1 1
  219. 35 3 3
  220. 37 2 2
  221. 41 1 1
  222. 42 2 2
  223. 43 1 1
  224. 44 1 1
  225. 47 1 1
  226. 51 2 2
  227. 53 1 1
  228. 54 1 1
  229. 57 1 1
  230. 58 2 2
  231. 64 1 1
  232. 65 1 1
  233. 66 1 1
  234. 67 2 2
  235. 69 1 1
  236. 70 3 3
  237. 72 2 2
  238. 74 1 1
  239. 76 2 2
  240. 77 1 1
  241. 78 1 1
  242. 80 1 1
  243. 82 1 1
  244. 83 2 2
  245. 84 2 2
  246. 85 1 1
  247. 86 1 1
  248. 87 1 1
  249. 90 3 3
  250. 92 1 1
  251. 95 2 2
  252. 96 1 1
  253. 97 2 2
  254. 98 2 2
  255. 100 2 2
  256. 103 2 2
  257. 104 2 2
  258. 105 1 1
  259. 111 1 1
  260. 113 2 2
  261. 114 1 1
  262. 116 1 1
  263. 118 2 2
  264. 119 3 3
  265. 120 2 2
  266. 125 2 2
  267. 126 1 1
  268. 128 3 3
  269. 129 2 2
  270. 131 1 1
  271. 133 1 1
  272. 134 2 2
  273. 136 1 1
  274. 137 2 2
  275. 138 4 4
  276. 143 1 1
  277. 145 1 1
  278. 146 2 2
  279. 149 2 2
  280. 150 1 1
  281. 152 2 2
  282. 153 1 1
  283. 155 1 1
  284. 156 1 1
  285. 157 1 1
  286. 158 1 1
  287. 160 1 1
  288. 162 1 1
  289. 163 1 1
  290. 164 2 2
  291. 165 2 2
  292. 166 1 1
  293. 167 3 3
  294. 168 1 1
  295. 169 4 4
  296. 170 1 1
  297. 172 2 2
  298. 174 2 2
  299. 175 2 2
  300. 176 2 2
  301. 177 1 1
  302. 178 1 1
  303. 179 2 2
  304. 180 1 1
  305. 181 1 1
  306. 183 1 1
  307. 186 1 1
  308. 187 3 3
  309. 189 1 1
  310. 190 1 1
  311. 191 2 2
  312. 192 1 1
  313. 193 3 3
  314. 194 1 1
  315. 195 2 2
  316. 196 1 1
  317. 197 2 2
  318. 199 3 3
  319. 200 2 2
  320. 201 1 1
  321. 202 1 1
  322. 203 2 2
  323. 205 2 2
  324. 207 2 2
  325. 208 3 3
  326. 209 2 2
  327. 213 2 2
  328. 214 1 1
  329. 216 2 2
  330. 217 2 2
  331. 218 1 1
  332. 219 2 2
  333. 221 2 2
  334. 222 1 1
  335. 223 2 2
  336. 224 2 2
  337. 226 1 1
  338. 228 1 1
  339. 229 2 2
  340. 230 5 5
  341. 233 2 2
  342. 235 1 1
  343. 237 2 2
  344. 238 2 2
  345. 239 2 2
  346. 241 1 1
  347. 242 2 2
  348. 244 1 1
  349. 247 1 1
  350. 248 1 1
  351. 249 1 1
  352. 252 1 1
  353. 255 2 2
  354. 256 2 2
  355. 257 1 1
  356. 258 1 1
  357. 260 1 1
  358. 262 1 1
  359. 263 1 1
  360. 265 2 2
  361. 266 1 1
  362. 272 2 2
  363. 273 3 3
  364. 274 1 1
  365. 275 1 1
  366. 277 4 4
  367. 278 2 2
  368. 280 2 2
  369. 281 2 2
  370. 282 2 2
  371. 283 1 1
  372. 284 1 1
  373. 285 1 1
  374. 286 1 1
  375. 287 1 1
  376. 288 2 2
  377. 289 1 1
  378. 291 1 1
  379. 292 1 1
  380. 296 1 1
  381. 298 3 3
  382. 302 1 1
  383. 305 1 1
  384. 306 1 1
  385. 307 2 2
  386. 308 1 1
  387. 309 2 2
  388. 310 1 1
  389. 311 3 3
  390. 315 1 1
  391. 316 3 3
  392. 317 2 2
  393. 318 3 3
  394. 321 2 2
  395. 322 2 2
  396. 323 1 1
  397. 325 2 2
  398. 327 3 3
  399. 331 2 2
  400. 332 1 1
  401. 333 2 2
  402. 335 1 1
  403. 336 1 1
  404. 338 1 1
  405. 339 1 1
  406. 341 1 1
  407. 342 2 2
  408. 344 2 2
  409. 345 1 1
  410. 348 5 5
  411. 351 1 1
  412. 353 2 2
  413. 356 1 1
  414. 360 1 1
  415. 362 1 1
  416. 364 1 1
  417. 365 1 1
  418. 366 1 1
  419. 367 2 2
  420. 368 1 1
  421. 369 3 3
  422. 373 1 1
  423. 374 1 1
  424. 375 1 1
  425. 377 1 1
  426. 378 1 1
  427. 379 1 1
  428. 382 2 2
  429. 384 3 3
  430. 386 1 1
  431. 389 1 1
  432. 392 1 1
  433. 393 1 1
  434. 394 1 1
  435. 395 2 2
  436. 396 3 3
  437. 397 2 2
  438. 399 2 2
  439. 400 1 1
  440. 401 5 5
  441. 402 1 1
  442. 403 3 3
  443. 404 2 2
  444. 406 4 4
  445. 407 1 1
  446. 409 3 3
  447. 411 1 1
  448. 413 2 2
  449. 414 2 2
  450. 417 3 3
  451. 418 1 1
  452. 419 1 1
  453. 421 1 1
  454. 424 2 2
  455. 427 1 1
  456. 429 2 2
  457. 430 3 3
  458. 431 3 3
  459. 432 1 1
  460. 435 1 1
  461. 436 1 1
  462. 437 1 1
  463. 438 3 3
  464. 439 2 2
  465. 443 1 1
  466. 444 1 1
  467. 446 1 1
  468. 448 1 1
  469. 449 1 1
  470. 452 1 1
  471. 453 1 1
  472. 454 3 3
  473. 455 1 1
  474. 457 1 1
  475. 458 2 2
  476. 459 2 2
  477. 460 1 1
  478. 462 2 2
  479. 463 2 2
  480. 466 3 3
  481. 467 1 1
  482. 468 4 4
  483. 469 5 5
  484. 470 1 1
  485. 472 1 1
  486. 475 1 1
  487. 477 1 1
  488. 478 2 2
  489. 479 1 1
  490. 480 3 3
  491. 481 1 1
  492. 482 1 1
  493. 483 1 1
  494. 484 1 1
  495. 485 1 1
  496. 487 1 1
  497. 489 4 4
  498. 490 1 1
  499. 491 1 1
  500. 492 2 2
  501. 493 1 1
  502. 494 1 1
  503. 495 1 1
  504. 496 1 1
  505. 497 1 1
  506. 498 3 3