/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 

    

  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. 

  2. PREHOOK: type: CREATETABLE
    3. 

  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. 

  4. POSTHOOK: type: CREATETABLE
    5. 

  5. POSTHOOK: Output: default@smb_bucket_1
    6. 

  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. 

  7. PREHOOK: type: CREATETABLE
    8. 

  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. 

  9. POSTHOOK: type: CREATETABLE
    10. 

  10. POSTHOOK: Output: default@smb_bucket_2
    11. 

  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. 

  12. PREHOOK: type: CREATETABLE
    13. 

  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. 

  14. POSTHOOK: type: CREATETABLE
    15. 

  15. POSTHOOK: Output: default@smb_bucket_3
    16. 

  16. PREHOOK: query: load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1
    17. 

  17. PREHOOK: type: LOAD
    18. 

  18. PREHOOK: Output: default@smb_bucket_1
    19. 

  19. POSTHOOK: query: load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1
    20. 

  20. POSTHOOK: type: LOAD
    21. 

  21. POSTHOOK: Output: default@smb_bucket_1
    22. 

  22. PREHOOK: query: load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2
    23. 

  23. PREHOOK: type: LOAD
    24. 

  24. PREHOOK: Output: default@smb_bucket_2
    25. 

  25. POSTHOOK: query: load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2
    26. 

  26. POSTHOOK: type: LOAD
    27. 

  27. POSTHOOK: Output: default@smb_bucket_2
    28. 

  28. PREHOOK: query: load data local inpath '../data/files/smbbucket_3.rc' overwrite into table smb_bucket_3
    29. 

  29. PREHOOK: type: LOAD
    30. 

  30. PREHOOK: Output: default@smb_bucket_3
    31. 

  31. POSTHOOK: query: load data local inpath '../data/files/smbbucket_3.rc' overwrite into table smb_bucket_3
    32. 

  32. POSTHOOK: type: LOAD
    33. 

  33. POSTHOOK: Output: default@smb_bucket_3
    34. 

  34. PREHOOK: query: explain
    35. 

  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. 

  36. PREHOOK: type: QUERY
    37. 

  37. POSTHOOK: query: explain
    38. 

  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. 

  39. POSTHOOK: type: QUERY
    40. 

  40. ABSTRACT SYNTAX TREE:
    41. 

  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. 

  42. 

  43. STAGE DEPENDENCIES:
    44. 

  44.   Stage-1 is a root stage
    45. 

  45.   Stage-0 is a root stage
    46. 

  46. 

  47. STAGE PLANS:
    48. 

  48.   Stage: Stage-1
    49. 

  49.     Map Reduce
    50. 

  50.       Alias -> Map Operator Tree:
    51. 

  51.         c 
    52. 

  52.           TableScan
    53. 

  53.             alias: c
    54. 

  54.             Sorted Merge Bucket Map Join Operator
    55. 

  55.               condition map:
    56. 

  56.                    Inner Join 0 to 1
    57. 

  57.                    Inner Join 1 to 2
    58. 

  58.               condition expressions:
    59. 

  59.                 0 {key} {value}
    60. 

  60.                 1 {key} {value}
    61. 

  61.                 2 {key} {value}
    62. 

  62.               handleSkewJoin: false
    63. 

  63.               keys:
    64. 

  64.                 0 [Column[key]]
    65. 

  65.                 1 [Column[key]]
    66. 

  66.                 2 [Column[key]]
    67. 

  67.               outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
    68. 

  68.               Position of Big Table: 2
    69. 

  69.               Select Operator
    70. 

  70.                 expressions:
    71. 

  71.                       expr: _col0
    72. 

  72.                       type: int
    73. 

  73.                       expr: _col1
    74. 

  74.                       type: string
    75. 

  75.                       expr: _col4
    76. 

  76.                       type: int
    77. 

  77.                       expr: _col5
    78. 

  78.                       type: string
    79. 

  79.                       expr: _col8
    80. 

  80.                       type: int
    81. 

  81.                       expr: _col9
    82. 

  82.                       type: string
    83. 

  83.                 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
    84. 

  84.                 Select Operator
    85. 

  85.                   expressions:
    86. 

  86.                         expr: _col0
    87. 

  87.                         type: int
    88. 

  88.                         expr: _col1
    89. 

  89.                         type: string
    90. 

  90.                         expr: _col4
    91. 

  91.                         type: int
    92. 

  92.                         expr: _col5
    93. 

  93.                         type: string
    94. 

  94.                         expr: _col8
    95. 

  95.                         type: int
    96. 

  96.                         expr: _col9
    97. 

  97.                         type: string
    98. 

  98.                   outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
    99. 

  99.                   File Output Operator
    100. 

  100.                     compressed: false
    101. 

  101.                     GlobalTableId: 0
    102. 

  102.                     table:
    103. 

  103.                         input format: org.apache.hadoop.mapred.TextInputFormat
    104. 

  104.                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    105. 

  105. 

  106.   Stage: Stage-0
    107. 

  107.     Fetch Operator
    108. 

  108.       limit: -1
    109. 

  109. 

  110. 

  111. 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
    112. 

  112. PREHOOK: type: QUERY
    113. 

  113. PREHOOK: Input: default@smb_bucket_1
    114. 

  114. PREHOOK: Input: default@smb_bucket_2
    115. 

  115. PREHOOK: Input: default@smb_bucket_3
    116. 

  116. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-16-49_321_3966901017045056953/-mr-10000
    117. 

  117. 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
    118. 

  118. POSTHOOK: type: QUERY
    119. 

  119. POSTHOOK: Input: default@smb_bucket_1
    120. 

  120. POSTHOOK: Input: default@smb_bucket_2
    121. 

  121. POSTHOOK: Input: default@smb_bucket_3
    122. 

  122. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-16-49_321_3966901017045056953/-mr-10000
    123. 

  123. PREHOOK: query: explain
    124. 

  124. 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
    125. 

  125. PREHOOK: type: QUERY
    126. 

  126. POSTHOOK: query: explain
    127. 

  127. 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
    128. 

  128. POSTHOOK: type: QUERY
    129. 

  129. ABSTRACT SYNTAX TREE:
    130. 

  130.   (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))))
    131. 

  131. 

  132. STAGE DEPENDENCIES:
    133. 

  133.   Stage-1 is a root stage
    134. 

  134.   Stage-0 is a root stage
    135. 

  135. 

  136. STAGE PLANS:
    137. 

  137.   Stage: Stage-1
    138. 

  138.     Map Reduce
    139. 

  139.       Alias -> Map Operator Tree:
    140. 

  140.         c 
    141. 

  141.           TableScan
    142. 

  142.             alias: c
    143. 

  143.             Sorted Merge Bucket Map Join Operator
    144. 

  144.               condition map:
    145. 

  145.                    Left Outer Join0 to 1
    146. 

  146.                    Inner Join 1 to 2
    147. 

  147.               condition expressions:
    148. 

  148.                 0 {key} {value}
    149. 

  149.                 1 {key} {value}
    150. 

  150.                 2 {key} {value}
    151. 

  151.               handleSkewJoin: false
    152. 

  152.               keys:
    153. 

  153.                 0 [Column[key]]
    154. 

  154.                 1 [Column[key]]
    155. 

  155.                 2 [Column[key]]
    156. 

  156.               outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
    157. 

  157.               Position of Big Table: 2
    158. 

  158.               Select Operator
    159. 

  159.                 expressions:
    160. 

  160.                       expr: _col0
    161. 

  161.                       type: int
    162. 

  162.                       expr: _col1
    163. 

  163.                       type: string
    164. 

  164.                       expr: _col4
    165. 

  165.                       type: int
    166. 

  166.                       expr: _col5
    167. 

  167.                       type: string
    168. 

  168.                       expr: _col8
    169. 

  169.                       type: int
    170. 

  170.                       expr: _col9
    171. 

  171.                       type: string
    172. 

  172.                 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
    173. 

  173.                 Select Operator
    174. 

  174.                   expressions:
    175. 

  175.                         expr: _col0
    176. 

  176.                         type: int
    177. 

  177.                         expr: _col1
    178. 

  178.                         type: string
    179. 

  179.                         expr: _col4
    180. 

  180.                         type: int
    181. 

  181.                         expr: _col5
    182. 

  182.                         type: string
    183. 

  183.                         expr: _col8
    184. 

  184.                         type: int
    185. 

  185.                         expr: _col9
    186. 

  186.                         type: string
    187. 

  187.                   outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
    188. 

  188.                   File Output Operator
    189. 

  189.                     compressed: false
    190. 

  190.                     GlobalTableId: 0
    191. 

  191.                     table:
    192. 

  192.                         input format: org.apache.hadoop.mapred.TextInputFormat
    193. 

  193.                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    194. 

  194. 

  195.   Stage: Stage-0
    196. 

  196.     Fetch Operator
    197. 

  197.       limit: -1
    198. 

  198. 

  199. 

  200. 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
    201. 

  201. PREHOOK: type: QUERY
    202. 

  202. PREHOOK: Input: default@smb_bucket_1
    203. 

  203. PREHOOK: Input: default@smb_bucket_2
    204. 

  204. PREHOOK: Input: default@smb_bucket_3
    205. 

  205. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-16-52_609_7903256946036561523/-mr-10000
    206. 

  206. 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
    207. 

  207. POSTHOOK: type: QUERY
    208. 

  208. POSTHOOK: Input: default@smb_bucket_1
    209. 

  209. POSTHOOK: Input: default@smb_bucket_2
    210. 

  210. POSTHOOK: Input: default@smb_bucket_3
    211. 

  211. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-16-52_609_7903256946036561523/-mr-10000
    212. 

  212. PREHOOK: query: explain
    213. 

  213. 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
    214. 

  214. PREHOOK: type: QUERY
    215. 

  215. POSTHOOK: query: explain
    216. 

  216. 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
    217. 

  217. POSTHOOK: type: QUERY
    218. 

  218. ABSTRACT SYNTAX TREE:
    219. 

  219.   (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))))
    220. 

  220. 

  221. STAGE DEPENDENCIES:
    222. 

  222.   Stage-1 is a root stage
    223. 

  223.   Stage-0 is a root stage
    224. 

  224. 

  225. STAGE PLANS:
    226. 

  226.   Stage: Stage-1
    227. 

  227.     Map Reduce
    228. 

  228.       Alias -> Map Operator Tree:
    229. 

  229.         c 
    230. 

  230.           TableScan
    231. 

  231.             alias: c
    232. 

  232.             Sorted Merge Bucket Map Join Operator
    233. 

  233.               condition map:
    234. 

  234.                    Left Outer Join0 to 1
    235. 

  235.                    Left Outer Join1 to 2
    236. 

  236.               condition expressions:
    237. 

  237.                 0 {key} {value}
    238. 

  238.                 1 {key} {value}
    239. 

  239.                 2 {key} {value}
    240. 

  240.               handleSkewJoin: false
    241. 

  241.               keys:
    242. 

  242.                 0 [Column[key]]
    243. 

  243.                 1 [Column[key]]
    244. 

  244.                 2 [Column[key]]
    245. 

  245.               outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
    246. 

  246.               Position of Big Table: 2
    247. 

  247.               Select Operator
    248. 

  248.                 expressions:
    249. 

  249.                       expr: _col0
    250. 

  250.                       type: int
    251. 

  251.                       expr: _col1
    252. 

  252.                       type: string
    253. 

  253.                       expr: _col4
    254. 

  254.                       type: int
    255. 

  255.                       expr: _col5
    256. 

  256.                       type: string
    257. 

  257.                       expr: _col8
    258. 

  258.                       type: int
    259. 

  259.                       expr: _col9
    260. 

  260.                       type: string
    261. 

  261.                 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
    262. 

  262.                 Select Operator
    263. 

  263.                   expressions:
    264. 

  264.                         expr: _col0
    265. 

  265.                         type: int
    266. 

  266.                         expr: _col1
    267. 

  267.                         type: string
    268. 

  268.                         expr: _col4
    269. 

  269.                         type: int
    270. 

  270.                         expr: _col5
    271. 

  271.                         type: string
    272. 

  272.                         expr: _col8
    273. 

  273.                         type: int
    274. 

  274.                         expr: _col9
    275. 

  275.                         type: string
    276. 

  276.                   outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
    277. 

  277.                   File Output Operator
    278. 

  278.                     compressed: false
    279. 

  279.                     GlobalTableId: 0
    280. 

  280.                     table:
    281. 

  281.                         input format: org.apache.hadoop.mapred.TextInputFormat
    282. 

  282.                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    283. 

  283. 

  284.   Stage: Stage-0
    285. 

  285.     Fetch Operator
    286. 

  286.       limit: -1
    287. 

  287. 

  288. 

  289. 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
    290. 

  290. PREHOOK: type: QUERY
    291. 

  291. PREHOOK: Input: default@smb_bucket_1
    292. 

  292. PREHOOK: Input: default@smb_bucket_2
    293. 

  293. PREHOOK: Input: default@smb_bucket_3
    294. 

  294. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-16-55_833_4731338482914814383/-mr-10000
    295. 

  295. 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
    296. 

  296. POSTHOOK: type: QUERY
    297. 

  297. POSTHOOK: Input: default@smb_bucket_1
    298. 

  298. POSTHOOK: Input: default@smb_bucket_2
    299. 

  299. POSTHOOK: Input: default@smb_bucket_3
    300. 

  300. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-16-55_833_4731338482914814383/-mr-10000
    301. 

  301. 1	val_1	NULL	NULL	NULL	NULL
    302. 

  302. 3	val_3	NULL	NULL	NULL	NULL
    303. 

  303. 4	val_4	NULL	NULL	NULL	NULL
    304. 

  304. 5	val_5	NULL	NULL	NULL	NULL
    305. 

  305. 10	val_10	NULL	NULL	NULL	NULL
    306. 

  306. PREHOOK: query: explain
    307. 

  307. 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
    308. 

  308. PREHOOK: type: QUERY
    309. 

  309. POSTHOOK: query: explain
    310. 

  310. 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
    311. 

  311. POSTHOOK: type: QUERY
    312. 

  312. ABSTRACT SYNTAX TREE:
    313. 

  313.   (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))))
    314. 

  314. 

  315. STAGE DEPENDENCIES:
    316. 

  316.   Stage-1 is a root stage
    317. 

  317.   Stage-0 is a root stage
    318. 

  318. 

  319. STAGE PLANS:
    320. 

  320.   Stage: Stage-1
    321. 

  321.     Map Reduce
    322. 

  322.       Alias -> Map Operator Tree:
    323. 

  323.         c 
    324. 

  324.           TableScan
    325. 

  325.             alias: c
    326. 

  326.             Sorted Merge Bucket Map Join Operator
    327. 

  327.               condition map:
    328. 

  328.                    Left Outer Join0 to 1
    329. 

  329.                    Right Outer Join1 to 2
    330. 

  330.               condition expressions:
    331. 

  331.                 0 {key} {value}
    332. 

  332.                 1 {key} {value}
    333. 

  333.                 2 {key} {value}
    334. 

  334.               handleSkewJoin: false
    335. 

  335.               keys:
    336. 

  336.                 0 [Column[key]]
    337. 

  337.                 1 [Column[key]]
    338. 

  338.                 2 [Column[key]]
    339. 

  339.               outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
    340. 

  340.               Position of Big Table: 2
    341. 

  341.               Select Operator
    342. 

  342.                 expressions:
    343. 

  343.                       expr: _col0
    344. 

  344.                       type: int
    345. 

  345.                       expr: _col1
    346. 

  346.                       type: string
    347. 

  347.                       expr: _col4
    348. 

  348.                       type: int
    349. 

  349.                       expr: _col5
    350. 

  350.                       type: string
    351. 

  351.                       expr: _col8
    352. 

  352.                       type: int
    353. 

  353.                       expr: _col9
    354. 

  354.                       type: string
    355. 

  355.                 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
    356. 

  356.                 Select Operator
    357. 

  357.                   expressions:
    358. 

  358.                         expr: _col0
    359. 

  359.                         type: int
    360. 

  360.                         expr: _col1
    361. 

  361.                         type: string
    362. 

  362.                         expr: _col4
    363. 

  363.                         type: int
    364. 

  364.                         expr: _col5
    365. 

  365.                         type: string
    366. 

  366.                         expr: _col8
    367. 

  367.                         type: int
    368. 

  368.                         expr: _col9
    369. 

  369.                         type: string
    370. 

  370.                   outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
    371. 

  371.                   File Output Operator
    372. 

  372.                     compressed: false
    373. 

  373.                     GlobalTableId: 0
    374. 

  374.                     table:
    375. 

  375.                         input format: org.apache.hadoop.mapred.TextInputFormat
    376. 

  376.                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    377. 

  377. 

  378.   Stage: Stage-0
    379. 

  379.     Fetch Operator
    380. 

  380.       limit: -1
    381. 

  381. 

  382. 

  383. 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
    384. 

  384. PREHOOK: type: QUERY
    385. 

  385. PREHOOK: Input: default@smb_bucket_1
    386. 

  386. PREHOOK: Input: default@smb_bucket_2
    387. 

  387. PREHOOK: Input: default@smb_bucket_3
    388. 

  388. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-16-59_060_6885897898144326961/-mr-10000
    389. 

  389. 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
    390. 

  390. POSTHOOK: type: QUERY
    391. 

  391. POSTHOOK: Input: default@smb_bucket_1
    392. 

  392. POSTHOOK: Input: default@smb_bucket_2
    393. 

  393. POSTHOOK: Input: default@smb_bucket_3
    394. 

  394. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-16-59_060_6885897898144326961/-mr-10000
    395. 

  395. NULL	NULL	NULL	NULL	4	val_4
    396. 

  396. NULL	NULL	NULL	NULL	10	val_10
    397. 

  397. NULL	NULL	NULL	NULL	17	val_17
    398. 

  398. NULL	NULL	NULL	NULL	19	val_19
    399. 

  399. NULL	NULL	NULL	NULL	20	val_20
    400. 

  400. NULL	NULL	NULL	NULL	23	val_23
    401. 

  401. PREHOOK: query: explain
    402. 

  402. 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
    403. 

  403. PREHOOK: type: QUERY
    404. 

  404. POSTHOOK: query: explain
    405. 

  405. 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
    406. 

  406. POSTHOOK: type: QUERY
    407. 

  407. ABSTRACT SYNTAX TREE:
    408. 

  408.   (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))))
    409. 

  409. 

  410. STAGE DEPENDENCIES:
    411. 

  411.   Stage-1 is a root stage
    412. 

  412.   Stage-0 is a root stage
    413. 

  413. 

  414. STAGE PLANS:
    415. 

  415.   Stage: Stage-1
    416. 

  416.     Map Reduce
    417. 

  417.       Alias -> Map Operator Tree:
    418. 

  418.         c 
    419. 

  419.           TableScan
    420. 

  420.             alias: c
    421. 

  421.             Sorted Merge Bucket Map Join Operator
    422. 

  422.               condition map:
    423. 

  423.                    Left Outer Join0 to 1
    424. 

  424.                    Outer Join 1 to 2
    425. 

  425.               condition expressions:
    426. 

  426.                 0 {key} {value}
    427. 

  427.                 1 {key} {value}
    428. 

  428.                 2 {key} {value}
    429. 

  429.               handleSkewJoin: false
    430. 

  430.               keys:
    431. 

  431.                 0 [Column[key]]
    432. 

  432.                 1 [Column[key]]
    433. 

  433.                 2 [Column[key]]
    434. 

  434.               outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
    435. 

  435.               Position of Big Table: 2
    436. 

  436.               Select Operator
    437. 

  437.                 expressions:
    438. 

  438.                       expr: _col0
    439. 

  439.                       type: int
    440. 

  440.                       expr: _col1
    441. 

  441.                       type: string
    442. 

  442.                       expr: _col4
    443. 

  443.                       type: int
    444. 

  444.                       expr: _col5
    445. 

  445.                       type: string
    446. 

  446.                       expr: _col8
    447. 

  447.                       type: int
    448. 

  448.                       expr: _col9
    449. 

  449.                       type: string
    450. 

  450.                 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
    451. 

  451.                 Select Operator
    452. 

  452.                   expressions:
    453. 

  453.                         expr: _col0
    454. 

  454.                         type: int
    455. 

  455.                         expr: _col1
    456. 

  456.                         type: string
    457. 

  457.                         expr: _col4
    458. 

  458.                         type: int
    459. 

  459.                         expr: _col5
    460. 

  460.                         type: string
    461. 

  461.                         expr: _col8
    462. 

  462.                         type: int
    463. 

  463.                         expr: _col9
    464. 

  464.                         type: string
    465. 

  465.                   outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
    466. 

  466.                   File Output Operator
    467. 

  467.                     compressed: false
    468. 

  468.                     GlobalTableId: 0
    469. 

  469.                     table:
    470. 

  470.                         input format: org.apache.hadoop.mapred.TextInputFormat
    471. 

  471.                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    472. 

  472. 

  473.   Stage: Stage-0
    474. 

  474.     Fetch Operator
    475. 

  475.       limit: -1
    476. 

  476. 

  477. 

  478. 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
    479. 

  479. PREHOOK: type: QUERY
    480. 

  480. PREHOOK: Input: default@smb_bucket_1
    481. 

  481. PREHOOK: Input: default@smb_bucket_2
    482. 

  482. PREHOOK: Input: default@smb_bucket_3
    483. 

  483. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-02_477_3066768832500086224/-mr-10000
    484. 

  484. 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
    485. 

  485. POSTHOOK: type: QUERY
    486. 

  486. POSTHOOK: Input: default@smb_bucket_1
    487. 

  487. POSTHOOK: Input: default@smb_bucket_2
    488. 

  488. POSTHOOK: Input: default@smb_bucket_3
    489. 

  489. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-02_477_3066768832500086224/-mr-10000
    490. 

  490. 1	val_1	NULL	NULL	NULL	NULL
    491. 

  491. 3	val_3	NULL	NULL	NULL	NULL
    492. 

  492. 4	val_4	NULL	NULL	NULL	NULL
    493. 

  493. NULL	NULL	NULL	NULL	4	val_4
    494. 

  494. 5	val_5	NULL	NULL	NULL	NULL
    495. 

  495. 10	val_10	NULL	NULL	NULL	NULL
    496. 

  496. NULL	NULL	NULL	NULL	10	val_10
    497. 

  497. NULL	NULL	NULL	NULL	17	val_17
    498. 

  498. NULL	NULL	NULL	NULL	19	val_19
    499. 

  499. NULL	NULL	NULL	NULL	20	val_20
    500. 

  500. NULL	NULL	NULL	NULL	23	val_23
    501. 

  501. PREHOOK: query: explain
    502. 

  502. 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
    503. 

  503. PREHOOK: type: QUERY
    504. 

  504. POSTHOOK: query: explain
    505. 

  505. 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
    506. 

  506. POSTHOOK: type: QUERY
    507. 

  507. ABSTRACT SYNTAX TREE:
    508. 

  508.   (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))))
    509. 

  509. 

  510. STAGE DEPENDENCIES:
    511. 

  511.   Stage-1 is a root stage
    512. 

  512.   Stage-0 is a root stage
    513. 

  513. 

  514. STAGE PLANS:
    515. 

  515.   Stage: Stage-1
    516. 

  516.     Map Reduce
    517. 

  517.       Alias -> Map Operator Tree:
    518. 

  518.         c 
    519. 

  519.           TableScan
    520. 

  520.             alias: c
    521. 

  521.             Sorted Merge Bucket Map Join Operator
    522. 

  522.               condition map:
    523. 

  523.                    Right Outer Join0 to 1
    524. 

  524.                    Inner Join 1 to 2
    525. 

  525.               condition expressions:
    526. 

  526.                 0 {key} {value}
    527. 

  527.                 1 {key} {value}
    528. 

  528.                 2 {key} {value}
    529. 

  529.               handleSkewJoin: false
    530. 

  530.               keys:
    531. 

  531.                 0 [Column[key]]
    532. 

  532.                 1 [Column[key]]
    533. 

  533.                 2 [Column[key]]
    534. 

  534.               outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
    535. 

  535.               Position of Big Table: 2
    536. 

  536.               Select Operator
    537. 

  537.                 expressions:
    538. 

  538.                       expr: _col0
    539. 

  539.                       type: int
    540. 

  540.                       expr: _col1
    541. 

  541.                       type: string
    542. 

  542.                       expr: _col4
    543. 

  543.                       type: int
    544. 

  544.                       expr: _col5
    545. 

  545.                       type: string
    546. 

  546.                       expr: _col8
    547. 

  547.                       type: int
    548. 

  548.                       expr: _col9
    549. 

  549.                       type: string
    550. 

  550.                 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
    551. 

  551.                 Select Operator
    552. 

  552.                   expressions:
    553. 

  553.                         expr: _col0
    554. 

  554.                         type: int
    555. 

  555.                         expr: _col1
    556. 

  556.                         type: string
    557. 

  557.                         expr: _col4
    558. 

  558.                         type: int
    559. 

  559.                         expr: _col5
    560. 

  560.                         type: string
    561. 

  561.                         expr: _col8
    562. 

  562.                         type: int
    563. 

  563.                         expr: _col9
    564. 

  564.                         type: string
    565. 

  565.                   outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
    566. 

  566.                   File Output Operator
    567. 

  567.                     compressed: false
    568. 

  568.                     GlobalTableId: 0
    569. 

  569.                     table:
    570. 

  570.                         input format: org.apache.hadoop.mapred.TextInputFormat
    571. 

  571.                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    572. 

  572. 

  573.   Stage: Stage-0
    574. 

  574.     Fetch Operator
    575. 

  575.       limit: -1
    576. 

  576. 

  577. 

  578. 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
    579. 

  579. PREHOOK: type: QUERY
    580. 

  580. PREHOOK: Input: default@smb_bucket_1
    581. 

  581. PREHOOK: Input: default@smb_bucket_2
    582. 

  582. PREHOOK: Input: default@smb_bucket_3
    583. 

  583. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-05_777_1313016308874669202/-mr-10000
    584. 

  584. 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
    585. 

  585. POSTHOOK: type: QUERY
    586. 

  586. POSTHOOK: Input: default@smb_bucket_1
    587. 

  587. POSTHOOK: Input: default@smb_bucket_2
    588. 

  588. POSTHOOK: Input: default@smb_bucket_3
    589. 

  589. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-05_777_1313016308874669202/-mr-10000
    590. 

  590. NULL	NULL	20	val_20	20	val_20
    591. 

  591. NULL	NULL	23	val_23	23	val_23
    592. 

  592. PREHOOK: query: explain
    593. 

  593. 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
    594. 

  594. PREHOOK: type: QUERY
    595. 

  595. POSTHOOK: query: explain
    596. 

  596. 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
    597. 

  597. POSTHOOK: type: QUERY
    598. 

  598. ABSTRACT SYNTAX TREE:
    599. 

  599.   (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))))
    600. 

  600. 

  601. STAGE DEPENDENCIES:
    602. 

  602.   Stage-1 is a root stage
    603. 

  603.   Stage-0 is a root stage
    604. 

  604. 

  605. STAGE PLANS:
    606. 

  606.   Stage: Stage-1
    607. 

  607.     Map Reduce
    608. 

  608.       Alias -> Map Operator Tree:
    609. 

  609.         c 
    610. 

  610.           TableScan
    611. 

  611.             alias: c
    612. 

  612.             Sorted Merge Bucket Map Join Operator
    613. 

  613.               condition map:
    614. 

  614.                    Right Outer Join0 to 1
    615. 

  615.                    Left Outer Join1 to 2
    616. 

  616.               condition expressions:
    617. 

  617.                 0 {key} {value}
    618. 

  618.                 1 {key} {value}
    619. 

  619.                 2 {key} {value}
    620. 

  620.               handleSkewJoin: false
    621. 

  621.               keys:
    622. 

  622.                 0 [Column[key]]
    623. 

  623.                 1 [Column[key]]
    624. 

  624.                 2 [Column[key]]
    625. 

  625.               outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
    626. 

  626.               Position of Big Table: 2
    627. 

  627.               Select Operator
    628. 

  628.                 expressions:
    629. 

  629.                       expr: _col0
    630. 

  630.                       type: int
    631. 

  631.                       expr: _col1
    632. 

  632.                       type: string
    633. 

  633.                       expr: _col4
    634. 

  634.                       type: int
    635. 

  635.                       expr: _col5
    636. 

  636.                       type: string
    637. 

  637.                       expr: _col8
    638. 

  638.                       type: int
    639. 

  639.                       expr: _col9
    640. 

  640.                       type: string
    641. 

  641.                 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
    642. 

  642.                 Select Operator
    643. 

  643.                   expressions:
    644. 

  644.                         expr: _col0
    645. 

  645.                         type: int
    646. 

  646.                         expr: _col1
    647. 

  647.                         type: string
    648. 

  648.                         expr: _col4
    649. 

  649.                         type: int
    650. 

  650.                         expr: _col5
    651. 

  651.                         type: string
    652. 

  652.                         expr: _col8
    653. 

  653.                         type: int
    654. 

  654.                         expr: _col9
    655. 

  655.                         type: string
    656. 

  656.                   outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
    657. 

  657.                   File Output Operator
    658. 

  658.                     compressed: false
    659. 

  659.                     GlobalTableId: 0
    660. 

  660.                     table:
    661. 

  661.                         input format: org.apache.hadoop.mapred.TextInputFormat
    662. 

  662.                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    663. 

  663. 

  664.   Stage: Stage-0
    665. 

  665.     Fetch Operator
    666. 

  666.       limit: -1
    667. 

  667. 

  668. 

  669. 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
    670. 

  670. PREHOOK: type: QUERY
    671. 

  671. PREHOOK: Input: default@smb_bucket_1
    672. 

  672. PREHOOK: Input: default@smb_bucket_2
    673. 

  673. PREHOOK: Input: default@smb_bucket_3
    674. 

  674. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-09_122_6064666085021507736/-mr-10000
    675. 

  675. 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
    676. 

  676. POSTHOOK: type: QUERY
    677. 

  677. POSTHOOK: Input: default@smb_bucket_1
    678. 

  678. POSTHOOK: Input: default@smb_bucket_2
    679. 

  679. POSTHOOK: Input: default@smb_bucket_3
    680. 

  680. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-09_122_6064666085021507736/-mr-10000
    681. 

  681. NULL	NULL	20	val_20	20	val_20
    682. 

  682. NULL	NULL	23	val_23	23	val_23
    683. 

  683. NULL	NULL	25	val_25	NULL	NULL
    684. 

  684. NULL	NULL	30	val_30	NULL	NULL
    685. 

  685. PREHOOK: query: explain
    686. 

  686. 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
    687. 

  687. PREHOOK: type: QUERY
    688. 

  688. POSTHOOK: query: explain
    689. 

  689. 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
    690. 

  690. POSTHOOK: type: QUERY
    691. 

  691. ABSTRACT SYNTAX TREE:
    692. 

  692.   (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))))
    693. 

  693. 

  694. STAGE DEPENDENCIES:
    695. 

  695.   Stage-1 is a root stage
    696. 

  696.   Stage-0 is a root stage
    697. 

  697. 

  698. STAGE PLANS:
    699. 

  699.   Stage: Stage-1
    700. 

  700.     Map Reduce
    701. 

  701.       Alias -> Map Operator Tree:
    702. 

  702.         c 
    703. 

  703.           TableScan
    704. 

  704.             alias: c
    705. 

  705.             Sorted Merge Bucket Map Join Operator
    706. 

  706.               condition map:
    707. 

  707.                    Right Outer Join0 to 1
    708. 

  708.                    Right Outer Join1 to 2
    709. 

  709.               condition expressions:
    710. 

  710.                 0 {key} {value}
    711. 

  711.                 1 {key} {value}
    712. 

  712.                 2 {key} {value}
    713. 

  713.               handleSkewJoin: false
    714. 

  714.               keys:
    715. 

  715.                 0 [Column[key]]
    716. 

  716.                 1 [Column[key]]
    717. 

  717.                 2 [Column[key]]
    718. 

  718.               outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
    719. 

  719.               Position of Big Table: 2
    720. 

  720.               Select Operator
    721. 

  721.                 expressions:
    722. 

  722.                       expr: _col0
    723. 

  723.                       type: int
    724. 

  724.                       expr: _col1
    725. 

  725.                       type: string
    726. 

  726.                       expr: _col4
    727. 

  727.                       type: int
    728. 

  728.                       expr: _col5
    729. 

  729.                       type: string
    730. 

  730.                       expr: _col8
    731. 

  731.                       type: int
    732. 

  732.                       expr: _col9
    733. 

  733.                       type: string
    734. 

  734.                 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
    735. 

  735.                 Select Operator
    736. 

  736.                   expressions:
    737. 

  737.                         expr: _col0
    738. 

  738.                         type: int
    739. 

  739.                         expr: _col1
    740. 

  740.                         type: string
    741. 

  741.                         expr: _col4
    742. 

  742.                         type: int
    743. 

  743.                         expr: _col5
    744. 

  744.                         type: string
    745. 

  745.                         expr: _col8
    746. 

  746.                         type: int
    747. 

  747.                         expr: _col9
    748. 

  748.                         type: string
    749. 

  749.                   outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
    750. 

  750.                   File Output Operator
    751. 

  751.                     compressed: false
    752. 

  752.                     GlobalTableId: 0
    753. 

  753.                     table:
    754. 

  754.                         input format: org.apache.hadoop.mapred.TextInputFormat
    755. 

  755.                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    756. 

  756. 

  757.   Stage: Stage-0
    758. 

  758.     Fetch Operator
    759. 

  759.       limit: -1
    760. 

  760. 

  761. 

  762. 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
    763. 

  763. PREHOOK: type: QUERY
    764. 

  764. PREHOOK: Input: default@smb_bucket_1
    765. 

  765. PREHOOK: Input: default@smb_bucket_2
    766. 

  766. PREHOOK: Input: default@smb_bucket_3
    767. 

  767. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-12_331_9066526170001430264/-mr-10000
    768. 

  768. 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
    769. 

  769. POSTHOOK: type: QUERY
    770. 

  770. POSTHOOK: Input: default@smb_bucket_1
    771. 

  771. POSTHOOK: Input: default@smb_bucket_2
    772. 

  772. POSTHOOK: Input: default@smb_bucket_3
    773. 

  773. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-12_331_9066526170001430264/-mr-10000
    774. 

  774. NULL	NULL	NULL	NULL	4	val_4
    775. 

  775. NULL	NULL	NULL	NULL	10	val_10
    776. 

  776. NULL	NULL	NULL	NULL	17	val_17
    777. 

  777. NULL	NULL	NULL	NULL	19	val_19
    778. 

  778. NULL	NULL	20	val_20	20	val_20
    779. 

  779. NULL	NULL	23	val_23	23	val_23
    780. 

  780. PREHOOK: query: explain
    781. 

  781. 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
    782. 

  782. PREHOOK: type: QUERY
    783. 

  783. POSTHOOK: query: explain
    784. 

  784. 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
    785. 

  785. POSTHOOK: type: QUERY
    786. 

  786. ABSTRACT SYNTAX TREE:
    787. 

  787.   (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))))
    788. 

  788. 

  789. STAGE DEPENDENCIES:
    790. 

  790.   Stage-1 is a root stage
    791. 

  791.   Stage-0 is a root stage
    792. 

  792. 

  793. STAGE PLANS:
    794. 

  794.   Stage: Stage-1
    795. 

  795.     Map Reduce
    796. 

  796.       Alias -> Map Operator Tree:
    797. 

  797.         c 
    798. 

  798.           TableScan
    799. 

  799.             alias: c
    800. 

  800.             Sorted Merge Bucket Map Join Operator
    801. 

  801.               condition map:
    802. 

  802.                    Right Outer Join0 to 1
    803. 

  803.                    Outer Join 1 to 2
    804. 

  804.               condition expressions:
    805. 

  805.                 0 {key} {value}
    806. 

  806.                 1 {key} {value}
    807. 

  807.                 2 {key} {value}
    808. 

  808.               handleSkewJoin: false
    809. 

  809.               keys:
    810. 

  810.                 0 [Column[key]]
    811. 

  811.                 1 [Column[key]]
    812. 

  812.                 2 [Column[key]]
    813. 

  813.               outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
    814. 

  814.               Position of Big Table: 2
    815. 

  815.               Select Operator
    816. 

  816.                 expressions:
    817. 

  817.                       expr: _col0
    818. 

  818.                       type: int
    819. 

  819.                       expr: _col1
    820. 

  820.                       type: string
    821. 

  821.                       expr: _col4
    822. 

  822.                       type: int
    823. 

  823.                       expr: _col5
    824. 

  824.                       type: string
    825. 

  825.                       expr: _col8
    826. 

  826.                       type: int
    827. 

  827.                       expr: _col9
    828. 

  828.                       type: string
    829. 

  829.                 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
    830. 

  830.                 Select Operator
    831. 

  831.                   expressions:
    832. 

  832.                         expr: _col0
    833. 

  833.                         type: int
    834. 

  834.                         expr: _col1
    835. 

  835.                         type: string
    836. 

  836.                         expr: _col4
    837. 

  837.                         type: int
    838. 

  838.                         expr: _col5
    839. 

  839.                         type: string
    840. 

  840.                         expr: _col8
    841. 

  841.                         type: int
    842. 

  842.                         expr: _col9
    843. 

  843.                         type: string
    844. 

  844.                   outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
    845. 

  845.                   File Output Operator
    846. 

  846.                     compressed: false
    847. 

  847.                     GlobalTableId: 0
    848. 

  848.                     table:
    849. 

  849.                         input format: org.apache.hadoop.mapred.TextInputFormat
    850. 

  850.                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    851. 

  851. 

  852.   Stage: Stage-0
    853. 

  853.     Fetch Operator
    854. 

  854.       limit: -1
    855. 

  855. 

  856. 

  857. 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
    858. 

  858. PREHOOK: type: QUERY
    859. 

  859. PREHOOK: Input: default@smb_bucket_1
    860. 

  860. PREHOOK: Input: default@smb_bucket_2
    861. 

  861. PREHOOK: Input: default@smb_bucket_3
    862. 

  862. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-15_548_3077982864155533470/-mr-10000
    863. 

  863. 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
    864. 

  864. POSTHOOK: type: QUERY
    865. 

  865. POSTHOOK: Input: default@smb_bucket_1
    866. 

  866. POSTHOOK: Input: default@smb_bucket_2
    867. 

  867. POSTHOOK: Input: default@smb_bucket_3
    868. 

  868. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-15_548_3077982864155533470/-mr-10000
    869. 

  869. NULL	NULL	NULL	NULL	4	val_4
    870. 

  870. NULL	NULL	NULL	NULL	10	val_10
    871. 

  871. NULL	NULL	NULL	NULL	17	val_17
    872. 

  872. NULL	NULL	NULL	NULL	19	val_19
    873. 

  873. NULL	NULL	20	val_20	20	val_20
    874. 

  874. NULL	NULL	23	val_23	23	val_23
    875. 

  875. NULL	NULL	25	val_25	NULL	NULL
    876. 

  876. NULL	NULL	30	val_30	NULL	NULL
    877. 

  877. PREHOOK: query: explain
    878. 

  878. 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
    879. 

  879. PREHOOK: type: QUERY
    880. 

  880. POSTHOOK: query: explain
    881. 

  881. 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
    882. 

  882. POSTHOOK: type: QUERY
    883. 

  883. ABSTRACT SYNTAX TREE:
    884. 

  884.   (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))))
    885. 

  885. 

  886. STAGE DEPENDENCIES:
    887. 

  887.   Stage-1 is a root stage
    888. 

  888.   Stage-0 is a root stage
    889. 

  889. 

  890. STAGE PLANS:
    891. 

  891.   Stage: Stage-1
    892. 

  892.     Map Reduce
    893. 

  893.       Alias -> Map Operator Tree:
    894. 

  894.         c 
    895. 

  895.           TableScan
    896. 

  896.             alias: c
    897. 

  897.             Sorted Merge Bucket Map Join Operator
    898. 

  898.               condition map:
    899. 

  899.                    Outer Join 0 to 1
    900. 

  900.                    Inner Join 1 to 2
    901. 

  901.               condition expressions:
    902. 

  902.                 0 {key} {value}
    903. 

  903.                 1 {key} {value}
    904. 

  904.                 2 {key} {value}
    905. 

  905.               handleSkewJoin: false
    906. 

  906.               keys:
    907. 

  907.                 0 [Column[key]]
    908. 

  908.                 1 [Column[key]]
    909. 

  909.                 2 [Column[key]]
    910. 

  910.               outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
    911. 

  911.               Position of Big Table: 2
    912. 

  912.               Select Operator
    913. 

  913.                 expressions:
    914. 

  914.                       expr: _col0
    915. 

  915.                       type: int
    916. 

  916.                       expr: _col1
    917. 

  917.                       type: string
    918. 

  918.                       expr: _col4
    919. 

  919.                       type: int
    920. 

  920.                       expr: _col5
    921. 

  921.                       type: string
    922. 

  922.                       expr: _col8
    923. 

  923.                       type: int
    924. 

  924.                       expr: _col9
    925. 

  925.                       type: string
    926. 

  926.                 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
    927. 

  927.                 Select Operator
    928. 

  928.                   expressions:
    929. 

  929.                         expr: _col0
    930. 

  930.                         type: int
    931. 

  931.                         expr: _col1
    932. 

  932.                         type: string
    933. 

  933.                         expr: _col4
    934. 

  934.                         type: int
    935. 

  935.                         expr: _col5
    936. 

  936.                         type: string
    937. 

  937.                         expr: _col8
    938. 

  938.                         type: int
    939. 

  939.                         expr: _col9
    940. 

  940.                         type: string
    941. 

  941.                   outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
    942. 

  942.                   File Output Operator
    943. 

  943.                     compressed: false
    944. 

  944.                     GlobalTableId: 0
    945. 

  945.                     table:
    946. 

  946.                         input format: org.apache.hadoop.mapred.TextInputFormat
    947. 

  947.                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    948. 

  948. 

  949.   Stage: Stage-0
    950. 

  950.     Fetch Operator
    951. 

  951.       limit: -1
    952. 

  952. 

  953. 

  954. 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
    955. 

  955. PREHOOK: type: QUERY
    956. 

  956. PREHOOK: Input: default@smb_bucket_1
    957. 

  957. PREHOOK: Input: default@smb_bucket_2
    958. 

  958. PREHOOK: Input: default@smb_bucket_3
    959. 

  959. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-18_783_1707777207222799965/-mr-10000
    960. 

  960. 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
    961. 

  961. POSTHOOK: type: QUERY
    962. 

  962. POSTHOOK: Input: default@smb_bucket_1
    963. 

  963. POSTHOOK: Input: default@smb_bucket_2
    964. 

  964. POSTHOOK: Input: default@smb_bucket_3
    965. 

  965. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-18_783_1707777207222799965/-mr-10000
    966. 

  966. NULL	NULL	20	val_20	20	val_20
    967. 

  967. NULL	NULL	23	val_23	23	val_23
    968. 

  968. PREHOOK: query: explain
    969. 

  969. 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
    970. 

  970. PREHOOK: type: QUERY
    971. 

  971. POSTHOOK: query: explain
    972. 

  972. 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
    973. 

  973. POSTHOOK: type: QUERY
    974. 

  974. ABSTRACT SYNTAX TREE:
    975. 

  975.   (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))))
    976. 

  976. 

  977. STAGE DEPENDENCIES:
    978. 

  978.   Stage-1 is a root stage
    979. 

  979.   Stage-0 is a root stage
    980. 

  980. 

  981. STAGE PLANS:
    982. 

  982.   Stage: Stage-1
    983. 

  983.     Map Reduce
    984. 

  984.       Alias -> Map Operator Tree:
    985. 

  985.         c 
    986. 

  986.           TableScan
    987. 

  987.             alias: c
    988. 

  988.             Sorted Merge Bucket Map Join Operator
    989. 

  989.               condition map:
    990. 

  990.                    Outer Join 0 to 1
    991. 

  991.                    Left Outer Join1 to 2
    992. 

  992.               condition expressions:
    993. 

  993.                 0 {key} {value}
    994. 

  994.                 1 {key} {value}
    995. 

  995.                 2 {key} {value}
    996. 

  996.               handleSkewJoin: false
    997. 

  997.               keys:
    998. 

  998.                 0 [Column[key]]
    999. 

  999.                 1 [Column[key]]
    1000. 

  1000.                 2 [Column[key]]
    1001. 

  1001.               outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
    1002. 

  1002.               Position of Big Table: 2
    1003. 

  1003.               Select Operator
    1004. 

  1004.                 expressions:
    1005. 

  1005.                       expr: _col0
    1006. 

  1006.                       type: int
    1007. 

  1007.                       expr: _col1
    1008. 

  1008.                       type: string
    1009. 

  1009.                       expr: _col4
    1010. 

  1010.                       type: int
    1011. 

  1011.                       expr: _col5
    1012. 

  1012.                       type: string
    1013. 

  1013.                       expr: _col8
    1014. 

  1014.                       type: int
    1015. 

  1015.                       expr: _col9
    1016. 

  1016.                       type: string
    1017. 

  1017.                 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
    1018. 

  1018.                 Select Operator
    1019. 

  1019.                   expressions:
    1020. 

  1020.                         expr: _col0
    1021. 

  1021.                         type: int
    1022. 

  1022.                         expr: _col1
    1023. 

  1023.                         type: string
    1024. 

  1024.                         expr: _col4
    1025. 

  1025.                         type: int
    1026. 

  1026.                         expr: _col5
    1027. 

  1027.                         type: string
    1028. 

  1028.                         expr: _col8
    1029. 

  1029.                         type: int
    1030. 

  1030.                         expr: _col9
    1031. 

  1031.                         type: string
    1032. 

  1032.                   outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
    1033. 

  1033.                   File Output Operator
    1034. 

  1034.                     compressed: false
    1035. 

  1035.                     GlobalTableId: 0
    1036. 

  1036.                     table:
    1037. 

  1037.                         input format: org.apache.hadoop.mapred.TextInputFormat
    1038. 

  1038.                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    1039. 

  1039. 

  1040.   Stage: Stage-0
    1041. 

  1041.     Fetch Operator
    1042. 

  1042.       limit: -1
    1043. 

  1043. 

  1044. 

  1045. 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
    1046. 

  1046. PREHOOK: type: QUERY
    1047. 

  1047. PREHOOK: Input: default@smb_bucket_1
    1048. 

  1048. PREHOOK: Input: default@smb_bucket_2
    1049. 

  1049. PREHOOK: Input: default@smb_bucket_3
    1050. 

  1050. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-22_135_3196413763184480906/-mr-10000
    1051. 

  1051. 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
    1052. 

  1052. POSTHOOK: type: QUERY
    1053. 

  1053. POSTHOOK: Input: default@smb_bucket_1
    1054. 

  1054. POSTHOOK: Input: default@smb_bucket_2
    1055. 

  1055. POSTHOOK: Input: default@smb_bucket_3
    1056. 

  1056. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-22_135_3196413763184480906/-mr-10000
    1057. 

  1057. 1	val_1	NULL	NULL	NULL	NULL
    1058. 

  1058. 3	val_3	NULL	NULL	NULL	NULL
    1059. 

  1059. 4	val_4	NULL	NULL	NULL	NULL
    1060. 

  1060. 5	val_5	NULL	NULL	NULL	NULL
    1061. 

  1061. 10	val_10	NULL	NULL	NULL	NULL
    1062. 

  1062. NULL	NULL	20	val_20	20	val_20
    1063. 

  1063. NULL	NULL	23	val_23	23	val_23
    1064. 

  1064. NULL	NULL	25	val_25	NULL	NULL
    1065. 

  1065. NULL	NULL	30	val_30	NULL	NULL
    1066. 

  1066. PREHOOK: query: explain
    1067. 

  1067. 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
    1068. 

  1068. PREHOOK: type: QUERY
    1069. 

  1069. POSTHOOK: query: explain
    1070. 

  1070. 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
    1071. 

  1071. POSTHOOK: type: QUERY
    1072. 

  1072. ABSTRACT SYNTAX TREE:
    1073. 

  1073.   (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))))
    1074. 

  1074. 

  1075. STAGE DEPENDENCIES:
    1076. 

  1076.   Stage-1 is a root stage
    1077. 

  1077.   Stage-0 is a root stage
    1078. 

  1078. 

  1079. STAGE PLANS:
    1080. 

  1080.   Stage: Stage-1
    1081. 

  1081.     Map Reduce
    1082. 

  1082.       Alias -> Map Operator Tree:
    1083. 

  1083.         c 
    1084. 

  1084.           TableScan
    1085. 

  1085.             alias: c
    1086. 

  1086.             Sorted Merge Bucket Map Join Operator
    1087. 

  1087.               condition map:
    1088. 

  1088.                    Outer Join 0 to 1
    1089. 

  1089.                    Right Outer Join1 to 2
    1090. 

  1090.               condition expressions:
    1091. 

  1091.                 0 {key} {value}
    1092. 

  1092.                 1 {key} {value}
    1093. 

  1093.                 2 {key} {value}
    1094. 

  1094.               handleSkewJoin: false
    1095. 

  1095.               keys:
    1096. 

  1096.                 0 [Column[key]]
    1097. 

  1097.                 1 [Column[key]]
    1098. 

  1098.                 2 [Column[key]]
    1099. 

  1099.               outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
    1100. 

  1100.               Position of Big Table: 2
    1101. 

  1101.               Select Operator
    1102. 

  1102.                 expressions:
    1103. 

  1103.                       expr: _col0
    1104. 

  1104.                       type: int
    1105. 

  1105.                       expr: _col1
    1106. 

  1106.                       type: string
    1107. 

  1107.                       expr: _col4
    1108. 

  1108.                       type: int
    1109. 

  1109.                       expr: _col5
    1110. 

  1110.                       type: string
    1111. 

  1111.                       expr: _col8
    1112. 

  1112.                       type: int
    1113. 

  1113.                       expr: _col9
    1114. 

  1114.                       type: string
    1115. 

  1115.                 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
    1116. 

  1116.                 Select Operator
    1117. 

  1117.                   expressions:
    1118. 

  1118.                         expr: _col0
    1119. 

  1119.                         type: int
    1120. 

  1120.                         expr: _col1
    1121. 

  1121.                         type: string
    1122. 

  1122.                         expr: _col4
    1123. 

  1123.                         type: int
    1124. 

  1124.                         expr: _col5
    1125. 

  1125.                         type: string
    1126. 

  1126.                         expr: _col8
    1127. 

  1127.                         type: int
    1128. 

  1128.                         expr: _col9
    1129. 

  1129.                         type: string
    1130. 

  1130.                   outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
    1131. 

  1131.                   File Output Operator
    1132. 

  1132.                     compressed: false
    1133. 

  1133.                     GlobalTableId: 0
    1134. 

  1134.                     table:
    1135. 

  1135.                         input format: org.apache.hadoop.mapred.TextInputFormat
    1136. 

  1136.                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    1137. 

  1137. 

  1138.   Stage: Stage-0
    1139. 

  1139.     Fetch Operator
    1140. 

  1140.       limit: -1
    1141. 

  1141. 

  1142. 

  1143. 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
    1144. 

  1144. PREHOOK: type: QUERY
    1145. 

  1145. PREHOOK: Input: default@smb_bucket_1
    1146. 

  1146. PREHOOK: Input: default@smb_bucket_2
    1147. 

  1147. PREHOOK: Input: default@smb_bucket_3
    1148. 

  1148. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-25_402_68522573808341044/-mr-10000
    1149. 

  1149. 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
    1150. 

  1150. POSTHOOK: type: QUERY
    1151. 

  1151. POSTHOOK: Input: default@smb_bucket_1
    1152. 

  1152. POSTHOOK: Input: default@smb_bucket_2
    1153. 

  1153. POSTHOOK: Input: default@smb_bucket_3
    1154. 

  1154. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-25_402_68522573808341044/-mr-10000
    1155. 

  1155. NULL	NULL	NULL	NULL	4	val_4
    1156. 

  1156. NULL	NULL	NULL	NULL	10	val_10
    1157. 

  1157. NULL	NULL	NULL	NULL	17	val_17
    1158. 

  1158. NULL	NULL	NULL	NULL	19	val_19
    1159. 

  1159. NULL	NULL	20	val_20	20	val_20
    1160. 

  1160. NULL	NULL	23	val_23	23	val_23
    1161. 

  1161. PREHOOK: query: explain
    1162. 

  1162. 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
    1163. 

  1163. PREHOOK: type: QUERY
    1164. 

  1164. POSTHOOK: query: explain
    1165. 

  1165. 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
    1166. 

  1166. POSTHOOK: type: QUERY
    1167. 

  1167. ABSTRACT SYNTAX TREE:
    1168. 

  1168.   (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))))
    1169. 

  1169. 

  1170. STAGE DEPENDENCIES:
    1171. 

  1171.   Stage-1 is a root stage
    1172. 

  1172.   Stage-0 is a root stage
    1173. 

  1173. 

  1174. STAGE PLANS:
    1175. 

  1175.   Stage: Stage-1
    1176. 

  1176.     Map Reduce
    1177. 

  1177.       Alias -> Map Operator Tree:
    1178. 

  1178.         c 
    1179. 

  1179.           TableScan
    1180. 

  1180.             alias: c
    1181. 

  1181.             Sorted Merge Bucket Map Join Operator
    1182. 

  1182.               condition map:
    1183. 

  1183.                    Outer Join 0 to 1
    1184. 

  1184.                    Outer Join 1 to 2
    1185. 

  1185.               condition expressions:
    1186. 

  1186.                 0 {key} {value}
    1187. 

  1187.                 1 {key} {value}
    1188. 

  1188.                 2 {key} {value}
    1189. 

  1189.               handleSkewJoin: false
    1190. 

  1190.               keys:
    1191. 

  1191.                 0 [Column[key]]
    1192. 

  1192.                 1 [Column[key]]
    1193. 

  1193.                 2 [Column[key]]
    1194. 

  1194.               outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
    1195. 

  1195.               Position of Big Table: 2
    1196. 

  1196.               Select Operator
    1197. 

  1197.                 expressions:
    1198. 

  1198.                       expr: _col0
    1199. 

  1199.                       type: int
    1200. 

  1200.                       expr: _col1
    1201. 

  1201.                       type: string
    1202. 

  1202.                       expr: _col4
    1203. 

  1203.                       type: int
    1204. 

  1204.                       expr: _col5
    1205. 

  1205.                       type: string
    1206. 

  1206.                       expr: _col8
    1207. 

  1207.                       type: int
    1208. 

  1208.                       expr: _col9
    1209. 

  1209.                       type: string
    1210. 

  1210.                 outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
    1211. 

  1211.                 Select Operator
    1212. 

  1212.                   expressions:
    1213. 

  1213.                         expr: _col0
    1214. 

  1214.                         type: int
    1215. 

  1215.                         expr: _col1
    1216. 

  1216.                         type: string
    1217. 

  1217.                         expr: _col4
    1218. 

  1218.                         type: int
    1219. 

  1219.                         expr: _col5
    1220. 

  1220.                         type: string
    1221. 

  1221.                         expr: _col8
    1222. 

  1222.                         type: int
    1223. 

  1223.                         expr: _col9
    1224. 

  1224.                         type: string
    1225. 

  1225.                   outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
    1226. 

  1226.                   File Output Operator
    1227. 

  1227.                     compressed: false
    1228. 

  1228.                     GlobalTableId: 0
    1229. 

  1229.                     table:
    1230. 

  1230.                         input format: org.apache.hadoop.mapred.TextInputFormat
    1231. 

  1231.                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
    1232. 

  1232. 

  1233.   Stage: Stage-0
    1234. 

  1234.     Fetch Operator
    1235. 

  1235.       limit: -1
    1236. 

  1236. 

  1237. 

  1238. 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
    1239. 

  1239. PREHOOK: type: QUERY
    1240. 

  1240. PREHOOK: Input: default@smb_bucket_1
    1241. 

  1241. PREHOOK: Input: default@smb_bucket_2
    1242. 

  1242. PREHOOK: Input: default@smb_bucket_3
    1243. 

  1243. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-28_578_3471954978455115358/-mr-10000
    1244. 

  1244. 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
    1245. 

  1245. POSTHOOK: type: QUERY
    1246. 

  1246. POSTHOOK: Input: default@smb_bucket_1
    1247. 

  1247. POSTHOOK: Input: default@smb_bucket_2
    1248. 

  1248. POSTHOOK: Input: default@smb_bucket_3
    1249. 

  1249. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-17-28_578_3471954978455115358/-mr-10000
    1250. 

  1250. 1	val_1	NULL	NULL	NULL	NULL
    1251. 

  1251. 3	val_3	NULL	NULL	NULL	NULL
    1252. 

  1252. 4	val_4	NULL	NULL	NULL	NULL
    1253. 

  1253. NULL	NULL	NULL	NULL	4	val_4
    1254. 

  1254. 5	val_5	NULL	NULL	NULL	NULL
    1255. 

  1255. 10	val_10	NULL	NULL	NULL	NULL
    1256. 

  1256. NULL	NULL	NULL	NULL	10	val_10
    1257. 

  1257. NULL	NULL	NULL	NULL	17	val_17
    1258. 

  1258. NULL	NULL	NULL	NULL	19	val_19
    1259. 

  1259. NULL	NULL	20	val_20	20	val_20
    1260. 

  1260. NULL	NULL	23	val_23	23	val_23
    1261. 

  1261. NULL	NULL	25	val_25	NULL	NULL
    1262. 

  1262. NULL	NULL	30	val_30	NULL	NULL
    1263.