PageRenderTime 52ms CodeModel.GetById 24ms RepoModel.GetById 0ms app.codeStats 0ms

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

#
text | 1262 lines | 1197 code | 65 blank | 0 comment | 0 complexity | c2d13e08e4de879779bfb6db2a0514f0 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
  1. PREHOOK: query: create table smb_bucket_1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE
  2. PREHOOK: type: CREATETABLE
  3. POSTHOOK: query: create table smb_bucket_1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE
  4. POSTHOOK: type: CREATETABLE
  5. POSTHOOK: Output: default@smb_bucket_1
  6. PREHOOK: query: create table smb_bucket_2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE
  7. PREHOOK: type: CREATETABLE
  8. POSTHOOK: query: create table smb_bucket_2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE
  9. POSTHOOK: type: CREATETABLE
  10. POSTHOOK: Output: default@smb_bucket_2
  11. PREHOOK: query: create table smb_bucket_3(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE
  12. PREHOOK: type: CREATETABLE
  13. POSTHOOK: query: create table smb_bucket_3(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE
  14. POSTHOOK: type: CREATETABLE
  15. POSTHOOK: Output: default@smb_bucket_3
  16. PREHOOK: query: load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1
  17. PREHOOK: type: LOAD
  18. PREHOOK: Output: default@smb_bucket_1
  19. POSTHOOK: query: load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1
  20. POSTHOOK: type: LOAD
  21. POSTHOOK: Output: default@smb_bucket_1
  22. PREHOOK: query: load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2
  23. PREHOOK: type: LOAD
  24. PREHOOK: Output: default@smb_bucket_2
  25. POSTHOOK: query: load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2
  26. POSTHOOK: type: LOAD
  27. POSTHOOK: Output: default@smb_bucket_2
  28. PREHOOK: query: load data local inpath '../data/files/smbbucket_3.rc' overwrite into table smb_bucket_3
  29. PREHOOK: type: LOAD
  30. PREHOOK: Output: default@smb_bucket_3
  31. POSTHOOK: query: load data local inpath '../data/files/smbbucket_3.rc' overwrite into table smb_bucket_3
  32. POSTHOOK: type: LOAD
  33. POSTHOOK: Output: default@smb_bucket_3
  34. PREHOOK: query: explain
  35. select /*+mapjoin(a,b)*/ * from smb_bucket_1 a join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key
  36. PREHOOK: type: QUERY
  37. POSTHOOK: query: explain
  38. select /*+mapjoin(a,b)*/ * from smb_bucket_1 a join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key
  39. POSTHOOK: type: QUERY
  40. ABSTRACT SYNTAX TREE:
  41. (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_JOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME smb_bucket_3) c) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL c) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a b))) (TOK_SELEXPR TOK_ALLCOLREF))))
  42. STAGE DEPENDENCIES:
  43. Stage-1 is a root stage
  44. Stage-0 is a root stage
  45. STAGE PLANS:
  46. Stage: Stage-1
  47. Map Reduce
  48. Alias -> Map Operator Tree:
  49. c
  50. TableScan
  51. alias: c
  52. Sorted Merge Bucket Map Join Operator
  53. condition map:
  54. Inner Join 0 to 1
  55. Inner Join 1 to 2
  56. condition expressions:
  57. 0 {key} {value}
  58. 1 {key} {value}
  59. 2 {key} {value}
  60. handleSkewJoin: false
  61. keys:
  62. 0 [Column[key]]
  63. 1 [Column[key]]
  64. 2 [Column[key]]
  65. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
  66. Position of Big Table: 2
  67. Select Operator
  68. expressions:
  69. expr: _col0
  70. type: int
  71. expr: _col1
  72. type: string
  73. expr: _col4
  74. type: int
  75. expr: _col5
  76. type: string
  77. expr: _col8
  78. type: int
  79. expr: _col9
  80. type: string
  81. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
  82. Select Operator
  83. expressions:
  84. expr: _col0
  85. type: int
  86. expr: _col1
  87. type: string
  88. expr: _col4
  89. type: int
  90. expr: _col5
  91. type: string
  92. expr: _col8
  93. type: int
  94. expr: _col9
  95. type: string
  96. outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
  97. File Output Operator
  98. compressed: false
  99. GlobalTableId: 0
  100. table:
  101. input format: org.apache.hadoop.mapred.TextInputFormat
  102. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  103. Stage: Stage-0
  104. Fetch Operator
  105. limit: -1
  106. PREHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key
  107. PREHOOK: type: QUERY
  108. PREHOOK: Input: default@smb_bucket_1
  109. PREHOOK: Input: default@smb_bucket_2
  110. PREHOOK: Input: default@smb_bucket_3
  111. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-16-49_321_3966901017045056953/-mr-10000
  112. POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key
  113. POSTHOOK: type: QUERY
  114. POSTHOOK: Input: default@smb_bucket_1
  115. POSTHOOK: Input: default@smb_bucket_2
  116. POSTHOOK: Input: default@smb_bucket_3
  117. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-16-49_321_3966901017045056953/-mr-10000
  118. PREHOOK: query: explain
  119. select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key
  120. PREHOOK: type: QUERY
  121. POSTHOOK: query: explain
  122. select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key
  123. POSTHOOK: type: QUERY
  124. ABSTRACT SYNTAX TREE:
  125. (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_LEFTOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME smb_bucket_3) c) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL c) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a b))) (TOK_SELEXPR TOK_ALLCOLREF))))
  126. STAGE DEPENDENCIES:
  127. Stage-1 is a root stage
  128. Stage-0 is a root stage
  129. STAGE PLANS:
  130. Stage: Stage-1
  131. Map Reduce
  132. Alias -> Map Operator Tree:
  133. c
  134. TableScan
  135. alias: c
  136. Sorted Merge Bucket Map Join Operator
  137. condition map:
  138. Left Outer Join0 to 1
  139. Inner Join 1 to 2
  140. condition expressions:
  141. 0 {key} {value}
  142. 1 {key} {value}
  143. 2 {key} {value}
  144. handleSkewJoin: false
  145. keys:
  146. 0 [Column[key]]
  147. 1 [Column[key]]
  148. 2 [Column[key]]
  149. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
  150. Position of Big Table: 2
  151. Select Operator
  152. expressions:
  153. expr: _col0
  154. type: int
  155. expr: _col1
  156. type: string
  157. expr: _col4
  158. type: int
  159. expr: _col5
  160. type: string
  161. expr: _col8
  162. type: int
  163. expr: _col9
  164. type: string
  165. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
  166. Select Operator
  167. expressions:
  168. expr: _col0
  169. type: int
  170. expr: _col1
  171. type: string
  172. expr: _col4
  173. type: int
  174. expr: _col5
  175. type: string
  176. expr: _col8
  177. type: int
  178. expr: _col9
  179. type: string
  180. outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
  181. File Output Operator
  182. compressed: false
  183. GlobalTableId: 0
  184. table:
  185. input format: org.apache.hadoop.mapred.TextInputFormat
  186. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  187. Stage: Stage-0
  188. Fetch Operator
  189. limit: -1
  190. PREHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key
  191. PREHOOK: type: QUERY
  192. PREHOOK: Input: default@smb_bucket_1
  193. PREHOOK: Input: default@smb_bucket_2
  194. PREHOOK: Input: default@smb_bucket_3
  195. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-16-52_609_7903256946036561523/-mr-10000
  196. POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key
  197. POSTHOOK: type: QUERY
  198. POSTHOOK: Input: default@smb_bucket_1
  199. POSTHOOK: Input: default@smb_bucket_2
  200. POSTHOOK: Input: default@smb_bucket_3
  201. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-16-52_609_7903256946036561523/-mr-10000
  202. PREHOOK: query: explain
  203. select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key
  204. PREHOOK: type: QUERY
  205. POSTHOOK: query: explain
  206. select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key
  207. POSTHOOK: type: QUERY
  208. ABSTRACT SYNTAX TREE:
  209. (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_LEFTOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME smb_bucket_3) c) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL c) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a b))) (TOK_SELEXPR TOK_ALLCOLREF))))
  210. STAGE DEPENDENCIES:
  211. Stage-1 is a root stage
  212. Stage-0 is a root stage
  213. STAGE PLANS:
  214. Stage: Stage-1
  215. Map Reduce
  216. Alias -> Map Operator Tree:
  217. c
  218. TableScan
  219. alias: c
  220. Sorted Merge Bucket Map Join Operator
  221. condition map:
  222. Left Outer Join0 to 1
  223. Left Outer Join1 to 2
  224. condition expressions:
  225. 0 {key} {value}
  226. 1 {key} {value}
  227. 2 {key} {value}
  228. handleSkewJoin: false
  229. keys:
  230. 0 [Column[key]]
  231. 1 [Column[key]]
  232. 2 [Column[key]]
  233. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
  234. Position of Big Table: 2
  235. Select Operator
  236. expressions:
  237. expr: _col0
  238. type: int
  239. expr: _col1
  240. type: string
  241. expr: _col4
  242. type: int
  243. expr: _col5
  244. type: string
  245. expr: _col8
  246. type: int
  247. expr: _col9
  248. type: string
  249. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
  250. Select Operator
  251. expressions:
  252. expr: _col0
  253. type: int
  254. expr: _col1
  255. type: string
  256. expr: _col4
  257. type: int
  258. expr: _col5
  259. type: string
  260. expr: _col8
  261. type: int
  262. expr: _col9
  263. type: string
  264. outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
  265. File Output Operator
  266. compressed: false
  267. GlobalTableId: 0
  268. table:
  269. input format: org.apache.hadoop.mapred.TextInputFormat
  270. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  271. Stage: Stage-0
  272. Fetch Operator
  273. limit: -1
  274. PREHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key
  275. PREHOOK: type: QUERY
  276. PREHOOK: Input: default@smb_bucket_1
  277. PREHOOK: Input: default@smb_bucket_2
  278. PREHOOK: Input: default@smb_bucket_3
  279. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-16-55_833_4731338482914814383/-mr-10000
  280. POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key
  281. POSTHOOK: type: QUERY
  282. POSTHOOK: Input: default@smb_bucket_1
  283. POSTHOOK: Input: default@smb_bucket_2
  284. POSTHOOK: Input: default@smb_bucket_3
  285. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-16-55_833_4731338482914814383/-mr-10000
  286. 1 val_1 NULL NULL NULL NULL
  287. 3 val_3 NULL NULL NULL NULL
  288. 4 val_4 NULL NULL NULL NULL
  289. 5 val_5 NULL NULL NULL NULL
  290. 10 val_10 NULL NULL NULL NULL
  291. PREHOOK: query: explain
  292. select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key
  293. PREHOOK: type: QUERY
  294. POSTHOOK: query: explain
  295. select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key
  296. POSTHOOK: type: QUERY
  297. ABSTRACT SYNTAX TREE:
  298. (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_LEFTOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME smb_bucket_3) c) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL c) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a b))) (TOK_SELEXPR TOK_ALLCOLREF))))
  299. STAGE DEPENDENCIES:
  300. Stage-1 is a root stage
  301. Stage-0 is a root stage
  302. STAGE PLANS:
  303. Stage: Stage-1
  304. Map Reduce
  305. Alias -> Map Operator Tree:
  306. c
  307. TableScan
  308. alias: c
  309. Sorted Merge Bucket Map Join Operator
  310. condition map:
  311. Left Outer Join0 to 1
  312. Right Outer Join1 to 2
  313. condition expressions:
  314. 0 {key} {value}
  315. 1 {key} {value}
  316. 2 {key} {value}
  317. handleSkewJoin: false
  318. keys:
  319. 0 [Column[key]]
  320. 1 [Column[key]]
  321. 2 [Column[key]]
  322. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
  323. Position of Big Table: 2
  324. Select Operator
  325. expressions:
  326. expr: _col0
  327. type: int
  328. expr: _col1
  329. type: string
  330. expr: _col4
  331. type: int
  332. expr: _col5
  333. type: string
  334. expr: _col8
  335. type: int
  336. expr: _col9
  337. type: string
  338. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
  339. Select Operator
  340. expressions:
  341. expr: _col0
  342. type: int
  343. expr: _col1
  344. type: string
  345. expr: _col4
  346. type: int
  347. expr: _col5
  348. type: string
  349. expr: _col8
  350. type: int
  351. expr: _col9
  352. type: string
  353. outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
  354. File Output Operator
  355. compressed: false
  356. GlobalTableId: 0
  357. table:
  358. input format: org.apache.hadoop.mapred.TextInputFormat
  359. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  360. Stage: Stage-0
  361. Fetch Operator
  362. limit: -1
  363. PREHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key
  364. PREHOOK: type: QUERY
  365. PREHOOK: Input: default@smb_bucket_1
  366. PREHOOK: Input: default@smb_bucket_2
  367. PREHOOK: Input: default@smb_bucket_3
  368. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-16-59_060_6885897898144326961/-mr-10000
  369. POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key
  370. POSTHOOK: type: QUERY
  371. POSTHOOK: Input: default@smb_bucket_1
  372. POSTHOOK: Input: default@smb_bucket_2
  373. POSTHOOK: Input: default@smb_bucket_3
  374. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-16-59_060_6885897898144326961/-mr-10000
  375. NULL NULL NULL NULL 4 val_4
  376. NULL NULL NULL NULL 10 val_10
  377. NULL NULL NULL NULL 17 val_17
  378. NULL NULL NULL NULL 19 val_19
  379. NULL NULL NULL NULL 20 val_20
  380. NULL NULL NULL NULL 23 val_23
  381. PREHOOK: query: explain
  382. select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key
  383. PREHOOK: type: QUERY
  384. POSTHOOK: query: explain
  385. select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key
  386. POSTHOOK: type: QUERY
  387. ABSTRACT SYNTAX TREE:
  388. (TOK_QUERY (TOK_FROM (TOK_FULLOUTERJOIN (TOK_LEFTOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME smb_bucket_3) c) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL c) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a b))) (TOK_SELEXPR TOK_ALLCOLREF))))
  389. STAGE DEPENDENCIES:
  390. Stage-1 is a root stage
  391. Stage-0 is a root stage
  392. STAGE PLANS:
  393. Stage: Stage-1
  394. Map Reduce
  395. Alias -> Map Operator Tree:
  396. c
  397. TableScan
  398. alias: c
  399. Sorted Merge Bucket Map Join Operator
  400. condition map:
  401. Left Outer Join0 to 1
  402. Outer Join 1 to 2
  403. condition expressions:
  404. 0 {key} {value}
  405. 1 {key} {value}
  406. 2 {key} {value}
  407. handleSkewJoin: false
  408. keys:
  409. 0 [Column[key]]
  410. 1 [Column[key]]
  411. 2 [Column[key]]
  412. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
  413. Position of Big Table: 2
  414. Select Operator
  415. expressions:
  416. expr: _col0
  417. type: int
  418. expr: _col1
  419. type: string
  420. expr: _col4
  421. type: int
  422. expr: _col5
  423. type: string
  424. expr: _col8
  425. type: int
  426. expr: _col9
  427. type: string
  428. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
  429. Select Operator
  430. expressions:
  431. expr: _col0
  432. type: int
  433. expr: _col1
  434. type: string
  435. expr: _col4
  436. type: int
  437. expr: _col5
  438. type: string
  439. expr: _col8
  440. type: int
  441. expr: _col9
  442. type: string
  443. outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
  444. File Output Operator
  445. compressed: false
  446. GlobalTableId: 0
  447. table:
  448. input format: org.apache.hadoop.mapred.TextInputFormat
  449. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  450. Stage: Stage-0
  451. Fetch Operator
  452. limit: -1
  453. PREHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key
  454. PREHOOK: type: QUERY
  455. PREHOOK: Input: default@smb_bucket_1
  456. PREHOOK: Input: default@smb_bucket_2
  457. PREHOOK: Input: default@smb_bucket_3
  458. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-02_477_3066768832500086224/-mr-10000
  459. POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key
  460. POSTHOOK: type: QUERY
  461. POSTHOOK: Input: default@smb_bucket_1
  462. POSTHOOK: Input: default@smb_bucket_2
  463. POSTHOOK: Input: default@smb_bucket_3
  464. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-02_477_3066768832500086224/-mr-10000
  465. 1 val_1 NULL NULL NULL NULL
  466. 3 val_3 NULL NULL NULL NULL
  467. 4 val_4 NULL NULL NULL NULL
  468. NULL NULL NULL NULL 4 val_4
  469. 5 val_5 NULL NULL NULL NULL
  470. 10 val_10 NULL NULL NULL NULL
  471. NULL NULL NULL NULL 10 val_10
  472. NULL NULL NULL NULL 17 val_17
  473. NULL NULL NULL NULL 19 val_19
  474. NULL NULL NULL NULL 20 val_20
  475. NULL NULL NULL NULL 23 val_23
  476. PREHOOK: query: explain
  477. select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key
  478. PREHOOK: type: QUERY
  479. POSTHOOK: query: explain
  480. select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key
  481. POSTHOOK: type: QUERY
  482. ABSTRACT SYNTAX TREE:
  483. (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_RIGHTOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME smb_bucket_3) c) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL c) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a b))) (TOK_SELEXPR TOK_ALLCOLREF))))
  484. STAGE DEPENDENCIES:
  485. Stage-1 is a root stage
  486. Stage-0 is a root stage
  487. STAGE PLANS:
  488. Stage: Stage-1
  489. Map Reduce
  490. Alias -> Map Operator Tree:
  491. c
  492. TableScan
  493. alias: c
  494. Sorted Merge Bucket Map Join Operator
  495. condition map:
  496. Right Outer Join0 to 1
  497. Inner Join 1 to 2
  498. condition expressions:
  499. 0 {key} {value}
  500. 1 {key} {value}
  501. 2 {key} {value}
  502. handleSkewJoin: false
  503. keys:
  504. 0 [Column[key]]
  505. 1 [Column[key]]
  506. 2 [Column[key]]
  507. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
  508. Position of Big Table: 2
  509. Select Operator
  510. expressions:
  511. expr: _col0
  512. type: int
  513. expr: _col1
  514. type: string
  515. expr: _col4
  516. type: int
  517. expr: _col5
  518. type: string
  519. expr: _col8
  520. type: int
  521. expr: _col9
  522. type: string
  523. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
  524. Select Operator
  525. expressions:
  526. expr: _col0
  527. type: int
  528. expr: _col1
  529. type: string
  530. expr: _col4
  531. type: int
  532. expr: _col5
  533. type: string
  534. expr: _col8
  535. type: int
  536. expr: _col9
  537. type: string
  538. outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
  539. File Output Operator
  540. compressed: false
  541. GlobalTableId: 0
  542. table:
  543. input format: org.apache.hadoop.mapred.TextInputFormat
  544. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  545. Stage: Stage-0
  546. Fetch Operator
  547. limit: -1
  548. PREHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key
  549. PREHOOK: type: QUERY
  550. PREHOOK: Input: default@smb_bucket_1
  551. PREHOOK: Input: default@smb_bucket_2
  552. PREHOOK: Input: default@smb_bucket_3
  553. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-05_777_1313016308874669202/-mr-10000
  554. POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key
  555. POSTHOOK: type: QUERY
  556. POSTHOOK: Input: default@smb_bucket_1
  557. POSTHOOK: Input: default@smb_bucket_2
  558. POSTHOOK: Input: default@smb_bucket_3
  559. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-05_777_1313016308874669202/-mr-10000
  560. NULL NULL 20 val_20 20 val_20
  561. NULL NULL 23 val_23 23 val_23
  562. PREHOOK: query: explain
  563. select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key
  564. PREHOOK: type: QUERY
  565. POSTHOOK: query: explain
  566. select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key
  567. POSTHOOK: type: QUERY
  568. ABSTRACT SYNTAX TREE:
  569. (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_RIGHTOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME smb_bucket_3) c) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL c) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a b))) (TOK_SELEXPR TOK_ALLCOLREF))))
  570. STAGE DEPENDENCIES:
  571. Stage-1 is a root stage
  572. Stage-0 is a root stage
  573. STAGE PLANS:
  574. Stage: Stage-1
  575. Map Reduce
  576. Alias -> Map Operator Tree:
  577. c
  578. TableScan
  579. alias: c
  580. Sorted Merge Bucket Map Join Operator
  581. condition map:
  582. Right Outer Join0 to 1
  583. Left Outer Join1 to 2
  584. condition expressions:
  585. 0 {key} {value}
  586. 1 {key} {value}
  587. 2 {key} {value}
  588. handleSkewJoin: false
  589. keys:
  590. 0 [Column[key]]
  591. 1 [Column[key]]
  592. 2 [Column[key]]
  593. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
  594. Position of Big Table: 2
  595. Select Operator
  596. expressions:
  597. expr: _col0
  598. type: int
  599. expr: _col1
  600. type: string
  601. expr: _col4
  602. type: int
  603. expr: _col5
  604. type: string
  605. expr: _col8
  606. type: int
  607. expr: _col9
  608. type: string
  609. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
  610. Select Operator
  611. expressions:
  612. expr: _col0
  613. type: int
  614. expr: _col1
  615. type: string
  616. expr: _col4
  617. type: int
  618. expr: _col5
  619. type: string
  620. expr: _col8
  621. type: int
  622. expr: _col9
  623. type: string
  624. outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
  625. File Output Operator
  626. compressed: false
  627. GlobalTableId: 0
  628. table:
  629. input format: org.apache.hadoop.mapred.TextInputFormat
  630. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  631. Stage: Stage-0
  632. Fetch Operator
  633. limit: -1
  634. PREHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key
  635. PREHOOK: type: QUERY
  636. PREHOOK: Input: default@smb_bucket_1
  637. PREHOOK: Input: default@smb_bucket_2
  638. PREHOOK: Input: default@smb_bucket_3
  639. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-09_122_6064666085021507736/-mr-10000
  640. POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key
  641. POSTHOOK: type: QUERY
  642. POSTHOOK: Input: default@smb_bucket_1
  643. POSTHOOK: Input: default@smb_bucket_2
  644. POSTHOOK: Input: default@smb_bucket_3
  645. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-09_122_6064666085021507736/-mr-10000
  646. NULL NULL 20 val_20 20 val_20
  647. NULL NULL 23 val_23 23 val_23
  648. NULL NULL 25 val_25 NULL NULL
  649. NULL NULL 30 val_30 NULL NULL
  650. PREHOOK: query: explain
  651. select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key
  652. PREHOOK: type: QUERY
  653. POSTHOOK: query: explain
  654. select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key
  655. POSTHOOK: type: QUERY
  656. ABSTRACT SYNTAX TREE:
  657. (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_RIGHTOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME smb_bucket_3) c) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL c) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a b))) (TOK_SELEXPR TOK_ALLCOLREF))))
  658. STAGE DEPENDENCIES:
  659. Stage-1 is a root stage
  660. Stage-0 is a root stage
  661. STAGE PLANS:
  662. Stage: Stage-1
  663. Map Reduce
  664. Alias -> Map Operator Tree:
  665. c
  666. TableScan
  667. alias: c
  668. Sorted Merge Bucket Map Join Operator
  669. condition map:
  670. Right Outer Join0 to 1
  671. Right Outer Join1 to 2
  672. condition expressions:
  673. 0 {key} {value}
  674. 1 {key} {value}
  675. 2 {key} {value}
  676. handleSkewJoin: false
  677. keys:
  678. 0 [Column[key]]
  679. 1 [Column[key]]
  680. 2 [Column[key]]
  681. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
  682. Position of Big Table: 2
  683. Select Operator
  684. expressions:
  685. expr: _col0
  686. type: int
  687. expr: _col1
  688. type: string
  689. expr: _col4
  690. type: int
  691. expr: _col5
  692. type: string
  693. expr: _col8
  694. type: int
  695. expr: _col9
  696. type: string
  697. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
  698. Select Operator
  699. expressions:
  700. expr: _col0
  701. type: int
  702. expr: _col1
  703. type: string
  704. expr: _col4
  705. type: int
  706. expr: _col5
  707. type: string
  708. expr: _col8
  709. type: int
  710. expr: _col9
  711. type: string
  712. outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
  713. File Output Operator
  714. compressed: false
  715. GlobalTableId: 0
  716. table:
  717. input format: org.apache.hadoop.mapred.TextInputFormat
  718. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  719. Stage: Stage-0
  720. Fetch Operator
  721. limit: -1
  722. PREHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key
  723. PREHOOK: type: QUERY
  724. PREHOOK: Input: default@smb_bucket_1
  725. PREHOOK: Input: default@smb_bucket_2
  726. PREHOOK: Input: default@smb_bucket_3
  727. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-12_331_9066526170001430264/-mr-10000
  728. POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key
  729. POSTHOOK: type: QUERY
  730. POSTHOOK: Input: default@smb_bucket_1
  731. POSTHOOK: Input: default@smb_bucket_2
  732. POSTHOOK: Input: default@smb_bucket_3
  733. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-12_331_9066526170001430264/-mr-10000
  734. NULL NULL NULL NULL 4 val_4
  735. NULL NULL NULL NULL 10 val_10
  736. NULL NULL NULL NULL 17 val_17
  737. NULL NULL NULL NULL 19 val_19
  738. NULL NULL 20 val_20 20 val_20
  739. NULL NULL 23 val_23 23 val_23
  740. PREHOOK: query: explain
  741. select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key
  742. PREHOOK: type: QUERY
  743. POSTHOOK: query: explain
  744. select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key
  745. POSTHOOK: type: QUERY
  746. ABSTRACT SYNTAX TREE:
  747. (TOK_QUERY (TOK_FROM (TOK_FULLOUTERJOIN (TOK_RIGHTOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME smb_bucket_3) c) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL c) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a b))) (TOK_SELEXPR TOK_ALLCOLREF))))
  748. STAGE DEPENDENCIES:
  749. Stage-1 is a root stage
  750. Stage-0 is a root stage
  751. STAGE PLANS:
  752. Stage: Stage-1
  753. Map Reduce
  754. Alias -> Map Operator Tree:
  755. c
  756. TableScan
  757. alias: c
  758. Sorted Merge Bucket Map Join Operator
  759. condition map:
  760. Right Outer Join0 to 1
  761. Outer Join 1 to 2
  762. condition expressions:
  763. 0 {key} {value}
  764. 1 {key} {value}
  765. 2 {key} {value}
  766. handleSkewJoin: false
  767. keys:
  768. 0 [Column[key]]
  769. 1 [Column[key]]
  770. 2 [Column[key]]
  771. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
  772. Position of Big Table: 2
  773. Select Operator
  774. expressions:
  775. expr: _col0
  776. type: int
  777. expr: _col1
  778. type: string
  779. expr: _col4
  780. type: int
  781. expr: _col5
  782. type: string
  783. expr: _col8
  784. type: int
  785. expr: _col9
  786. type: string
  787. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
  788. Select Operator
  789. expressions:
  790. expr: _col0
  791. type: int
  792. expr: _col1
  793. type: string
  794. expr: _col4
  795. type: int
  796. expr: _col5
  797. type: string
  798. expr: _col8
  799. type: int
  800. expr: _col9
  801. type: string
  802. outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
  803. File Output Operator
  804. compressed: false
  805. GlobalTableId: 0
  806. table:
  807. input format: org.apache.hadoop.mapred.TextInputFormat
  808. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  809. Stage: Stage-0
  810. Fetch Operator
  811. limit: -1
  812. PREHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key
  813. PREHOOK: type: QUERY
  814. PREHOOK: Input: default@smb_bucket_1
  815. PREHOOK: Input: default@smb_bucket_2
  816. PREHOOK: Input: default@smb_bucket_3
  817. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-15_548_3077982864155533470/-mr-10000
  818. POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a right outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key
  819. POSTHOOK: type: QUERY
  820. POSTHOOK: Input: default@smb_bucket_1
  821. POSTHOOK: Input: default@smb_bucket_2
  822. POSTHOOK: Input: default@smb_bucket_3
  823. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-15_548_3077982864155533470/-mr-10000
  824. NULL NULL NULL NULL 4 val_4
  825. NULL NULL NULL NULL 10 val_10
  826. NULL NULL NULL NULL 17 val_17
  827. NULL NULL NULL NULL 19 val_19
  828. NULL NULL 20 val_20 20 val_20
  829. NULL NULL 23 val_23 23 val_23
  830. NULL NULL 25 val_25 NULL NULL
  831. NULL NULL 30 val_30 NULL NULL
  832. PREHOOK: query: explain
  833. select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key
  834. PREHOOK: type: QUERY
  835. POSTHOOK: query: explain
  836. select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key
  837. POSTHOOK: type: QUERY
  838. ABSTRACT SYNTAX TREE:
  839. (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_FULLOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME smb_bucket_3) c) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL c) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a b))) (TOK_SELEXPR TOK_ALLCOLREF))))
  840. STAGE DEPENDENCIES:
  841. Stage-1 is a root stage
  842. Stage-0 is a root stage
  843. STAGE PLANS:
  844. Stage: Stage-1
  845. Map Reduce
  846. Alias -> Map Operator Tree:
  847. c
  848. TableScan
  849. alias: c
  850. Sorted Merge Bucket Map Join Operator
  851. condition map:
  852. Outer Join 0 to 1
  853. Inner Join 1 to 2
  854. condition expressions:
  855. 0 {key} {value}
  856. 1 {key} {value}
  857. 2 {key} {value}
  858. handleSkewJoin: false
  859. keys:
  860. 0 [Column[key]]
  861. 1 [Column[key]]
  862. 2 [Column[key]]
  863. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
  864. Position of Big Table: 2
  865. Select Operator
  866. expressions:
  867. expr: _col0
  868. type: int
  869. expr: _col1
  870. type: string
  871. expr: _col4
  872. type: int
  873. expr: _col5
  874. type: string
  875. expr: _col8
  876. type: int
  877. expr: _col9
  878. type: string
  879. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
  880. Select Operator
  881. expressions:
  882. expr: _col0
  883. type: int
  884. expr: _col1
  885. type: string
  886. expr: _col4
  887. type: int
  888. expr: _col5
  889. type: string
  890. expr: _col8
  891. type: int
  892. expr: _col9
  893. type: string
  894. outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
  895. File Output Operator
  896. compressed: false
  897. GlobalTableId: 0
  898. table:
  899. input format: org.apache.hadoop.mapred.TextInputFormat
  900. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  901. Stage: Stage-0
  902. Fetch Operator
  903. limit: -1
  904. PREHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key
  905. PREHOOK: type: QUERY
  906. PREHOOK: Input: default@smb_bucket_1
  907. PREHOOK: Input: default@smb_bucket_2
  908. PREHOOK: Input: default@smb_bucket_3
  909. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-18_783_1707777207222799965/-mr-10000
  910. POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key join smb_bucket_3 c on b.key=c.key
  911. POSTHOOK: type: QUERY
  912. POSTHOOK: Input: default@smb_bucket_1
  913. POSTHOOK: Input: default@smb_bucket_2
  914. POSTHOOK: Input: default@smb_bucket_3
  915. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-18_783_1707777207222799965/-mr-10000
  916. NULL NULL 20 val_20 20 val_20
  917. NULL NULL 23 val_23 23 val_23
  918. PREHOOK: query: explain
  919. select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key
  920. PREHOOK: type: QUERY
  921. POSTHOOK: query: explain
  922. select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key
  923. POSTHOOK: type: QUERY
  924. ABSTRACT SYNTAX TREE:
  925. (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_FULLOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME smb_bucket_3) c) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL c) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a b))) (TOK_SELEXPR TOK_ALLCOLREF))))
  926. STAGE DEPENDENCIES:
  927. Stage-1 is a root stage
  928. Stage-0 is a root stage
  929. STAGE PLANS:
  930. Stage: Stage-1
  931. Map Reduce
  932. Alias -> Map Operator Tree:
  933. c
  934. TableScan
  935. alias: c
  936. Sorted Merge Bucket Map Join Operator
  937. condition map:
  938. Outer Join 0 to 1
  939. Left Outer Join1 to 2
  940. condition expressions:
  941. 0 {key} {value}
  942. 1 {key} {value}
  943. 2 {key} {value}
  944. handleSkewJoin: false
  945. keys:
  946. 0 [Column[key]]
  947. 1 [Column[key]]
  948. 2 [Column[key]]
  949. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
  950. Position of Big Table: 2
  951. Select Operator
  952. expressions:
  953. expr: _col0
  954. type: int
  955. expr: _col1
  956. type: string
  957. expr: _col4
  958. type: int
  959. expr: _col5
  960. type: string
  961. expr: _col8
  962. type: int
  963. expr: _col9
  964. type: string
  965. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
  966. Select Operator
  967. expressions:
  968. expr: _col0
  969. type: int
  970. expr: _col1
  971. type: string
  972. expr: _col4
  973. type: int
  974. expr: _col5
  975. type: string
  976. expr: _col8
  977. type: int
  978. expr: _col9
  979. type: string
  980. outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
  981. File Output Operator
  982. compressed: false
  983. GlobalTableId: 0
  984. table:
  985. input format: org.apache.hadoop.mapred.TextInputFormat
  986. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  987. Stage: Stage-0
  988. Fetch Operator
  989. limit: -1
  990. PREHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key
  991. PREHOOK: type: QUERY
  992. PREHOOK: Input: default@smb_bucket_1
  993. PREHOOK: Input: default@smb_bucket_2
  994. PREHOOK: Input: default@smb_bucket_3
  995. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-22_135_3196413763184480906/-mr-10000
  996. POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key left outer join smb_bucket_3 c on b.key=c.key
  997. POSTHOOK: type: QUERY
  998. POSTHOOK: Input: default@smb_bucket_1
  999. POSTHOOK: Input: default@smb_bucket_2
  1000. POSTHOOK: Input: default@smb_bucket_3
  1001. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-22_135_3196413763184480906/-mr-10000
  1002. 1 val_1 NULL NULL NULL NULL
  1003. 3 val_3 NULL NULL NULL NULL
  1004. 4 val_4 NULL NULL NULL NULL
  1005. 5 val_5 NULL NULL NULL NULL
  1006. 10 val_10 NULL NULL NULL NULL
  1007. NULL NULL 20 val_20 20 val_20
  1008. NULL NULL 23 val_23 23 val_23
  1009. NULL NULL 25 val_25 NULL NULL
  1010. NULL NULL 30 val_30 NULL NULL
  1011. PREHOOK: query: explain
  1012. select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key
  1013. PREHOOK: type: QUERY
  1014. POSTHOOK: query: explain
  1015. select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key
  1016. POSTHOOK: type: QUERY
  1017. ABSTRACT SYNTAX TREE:
  1018. (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_FULLOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME smb_bucket_3) c) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL c) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a b))) (TOK_SELEXPR TOK_ALLCOLREF))))
  1019. STAGE DEPENDENCIES:
  1020. Stage-1 is a root stage
  1021. Stage-0 is a root stage
  1022. STAGE PLANS:
  1023. Stage: Stage-1
  1024. Map Reduce
  1025. Alias -> Map Operator Tree:
  1026. c
  1027. TableScan
  1028. alias: c
  1029. Sorted Merge Bucket Map Join Operator
  1030. condition map:
  1031. Outer Join 0 to 1
  1032. Right Outer Join1 to 2
  1033. condition expressions:
  1034. 0 {key} {value}
  1035. 1 {key} {value}
  1036. 2 {key} {value}
  1037. handleSkewJoin: false
  1038. keys:
  1039. 0 [Column[key]]
  1040. 1 [Column[key]]
  1041. 2 [Column[key]]
  1042. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
  1043. Position of Big Table: 2
  1044. Select Operator
  1045. expressions:
  1046. expr: _col0
  1047. type: int
  1048. expr: _col1
  1049. type: string
  1050. expr: _col4
  1051. type: int
  1052. expr: _col5
  1053. type: string
  1054. expr: _col8
  1055. type: int
  1056. expr: _col9
  1057. type: string
  1058. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
  1059. Select Operator
  1060. expressions:
  1061. expr: _col0
  1062. type: int
  1063. expr: _col1
  1064. type: string
  1065. expr: _col4
  1066. type: int
  1067. expr: _col5
  1068. type: string
  1069. expr: _col8
  1070. type: int
  1071. expr: _col9
  1072. type: string
  1073. outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
  1074. File Output Operator
  1075. compressed: false
  1076. GlobalTableId: 0
  1077. table:
  1078. input format: org.apache.hadoop.mapred.TextInputFormat
  1079. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  1080. Stage: Stage-0
  1081. Fetch Operator
  1082. limit: -1
  1083. PREHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key
  1084. PREHOOK: type: QUERY
  1085. PREHOOK: Input: default@smb_bucket_1
  1086. PREHOOK: Input: default@smb_bucket_2
  1087. PREHOOK: Input: default@smb_bucket_3
  1088. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-25_402_68522573808341044/-mr-10000
  1089. POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key right outer join smb_bucket_3 c on b.key=c.key
  1090. POSTHOOK: type: QUERY
  1091. POSTHOOK: Input: default@smb_bucket_1
  1092. POSTHOOK: Input: default@smb_bucket_2
  1093. POSTHOOK: Input: default@smb_bucket_3
  1094. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-25_402_68522573808341044/-mr-10000
  1095. NULL NULL NULL NULL 4 val_4
  1096. NULL NULL NULL NULL 10 val_10
  1097. NULL NULL NULL NULL 17 val_17
  1098. NULL NULL NULL NULL 19 val_19
  1099. NULL NULL 20 val_20 20 val_20
  1100. NULL NULL 23 val_23 23 val_23
  1101. PREHOOK: query: explain
  1102. select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key
  1103. PREHOOK: type: QUERY
  1104. POSTHOOK: query: explain
  1105. select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key
  1106. POSTHOOK: type: QUERY
  1107. ABSTRACT SYNTAX TREE:
  1108. (TOK_QUERY (TOK_FROM (TOK_FULLOUTERJOIN (TOK_FULLOUTERJOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key))) (TOK_TABREF (TOK_TABNAME smb_bucket_3) c) (= (. (TOK_TABLE_OR_COL b) key) (. (TOK_TABLE_OR_COL c) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST a b))) (TOK_SELEXPR TOK_ALLCOLREF))))
  1109. STAGE DEPENDENCIES:
  1110. Stage-1 is a root stage
  1111. Stage-0 is a root stage
  1112. STAGE PLANS:
  1113. Stage: Stage-1
  1114. Map Reduce
  1115. Alias -> Map Operator Tree:
  1116. c
  1117. TableScan
  1118. alias: c
  1119. Sorted Merge Bucket Map Join Operator
  1120. condition map:
  1121. Outer Join 0 to 1
  1122. Outer Join 1 to 2
  1123. condition expressions:
  1124. 0 {key} {value}
  1125. 1 {key} {value}
  1126. 2 {key} {value}
  1127. handleSkewJoin: false
  1128. keys:
  1129. 0 [Column[key]]
  1130. 1 [Column[key]]
  1131. 2 [Column[key]]
  1132. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
  1133. Position of Big Table: 2
  1134. Select Operator
  1135. expressions:
  1136. expr: _col0
  1137. type: int
  1138. expr: _col1
  1139. type: string
  1140. expr: _col4
  1141. type: int
  1142. expr: _col5
  1143. type: string
  1144. expr: _col8
  1145. type: int
  1146. expr: _col9
  1147. type: string
  1148. outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
  1149. Select Operator
  1150. expressions:
  1151. expr: _col0
  1152. type: int
  1153. expr: _col1
  1154. type: string
  1155. expr: _col4
  1156. type: int
  1157. expr: _col5
  1158. type: string
  1159. expr: _col8
  1160. type: int
  1161. expr: _col9
  1162. type: string
  1163. outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
  1164. File Output Operator
  1165. compressed: false
  1166. GlobalTableId: 0
  1167. table:
  1168. input format: org.apache.hadoop.mapred.TextInputFormat
  1169. output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  1170. Stage: Stage-0
  1171. Fetch Operator
  1172. limit: -1
  1173. PREHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key
  1174. PREHOOK: type: QUERY
  1175. PREHOOK: Input: default@smb_bucket_1
  1176. PREHOOK: Input: default@smb_bucket_2
  1177. PREHOOK: Input: default@smb_bucket_3
  1178. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-28_578_3471954978455115358/-mr-10000
  1179. POSTHOOK: query: select /*+mapjoin(a,b)*/ * from smb_bucket_1 a full outer join smb_bucket_2 b on a.key = b.key full outer join smb_bucket_3 c on b.key=c.key
  1180. POSTHOOK: type: QUERY
  1181. POSTHOOK: Input: default@smb_bucket_1
  1182. POSTHOOK: Input: default@smb_bucket_2
  1183. POSTHOOK: Input: default@smb_bucket_3
  1184. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-28_578_3471954978455115358/-mr-10000
  1185. 1 val_1 NULL NULL NULL NULL
  1186. 3 val_3 NULL NULL NULL NULL
  1187. 4 val_4 NULL NULL NULL NULL
  1188. NULL NULL NULL NULL 4 val_4
  1189. 5 val_5 NULL NULL NULL NULL
  1190. 10 val_10 NULL NULL NULL NULL
  1191. NULL NULL NULL NULL 10 val_10
  1192. NULL NULL NULL NULL 17 val_17
  1193. NULL NULL NULL NULL 19 val_19
  1194. NULL NULL 20 val_20 20 val_20
  1195. NULL NULL 23 val_23 23 val_23
  1196. NULL NULL 25 val_25 NULL NULL
  1197. NULL NULL 30 val_30 NULL NULL