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

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

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