PageRenderTime 51ms CodeModel.GetById 15ms RepoModel.GetById 0ms app.codeStats 0ms

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

#
text | 625 lines | 625 code | 0 blank | 0 comment | 0 complexity | 4b1361b138ac3cfb1806ef9496fbf803 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. PREHOOK: query: CREATE TABLE myinput1(key int, value int)
    2. 

  2. PREHOOK: type: CREATETABLE
    3. 

  3. POSTHOOK: query: CREATE TABLE myinput1(key int, value int)
    4. 

  4. POSTHOOK: type: CREATETABLE
    5. 

  5. POSTHOOK: Output: default@myinput1
    6. 

  6. PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in1.txt' INTO TABLE myinput1
    7. 

  7. PREHOOK: type: LOAD
    8. 

  8. PREHOOK: Output: default@myinput1
    9. 

  9. POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in1.txt' INTO TABLE myinput1
    10. 

  10. POSTHOOK: type: LOAD
    11. 

  11. POSTHOOK: Output: default@myinput1
    12. 

  12. PREHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b
    13. 

  13. PREHOOK: type: QUERY
    14. 

  14. PREHOOK: Input: default@myinput1
    15. 

  15. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-31_683_8641177538651570201/-mr-10000
    16. 

  16. POSTHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b
    17. 

  17. POSTHOOK: type: QUERY
    18. 

  18. POSTHOOK: Input: default@myinput1
    19. 

  19. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-31_683_8641177538651570201/-mr-10000
    20. 

  20. NULL	35	NULL	35
    21. 

  21. NULL	35	48	NULL
    22. 

  22. NULL	35	100	100
    23. 

  23. 48	NULL	NULL	35
    24. 

  24. 48	NULL	48	NULL
    25. 

  25. 48	NULL	100	100
    26. 

  26. 100	100	NULL	35
    27. 

  27. 100	100	48	NULL
    28. 

  28. 100	100	100	100
    29. 

  29. PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b
    30. 

  30. PREHOOK: type: QUERY
    31. 

  31. PREHOOK: Input: default@myinput1
    32. 

  32. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-34_705_7891360827662899707/-mr-10000
    33. 

  33. POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b
    34. 

  34. POSTHOOK: type: QUERY
    35. 

  35. POSTHOOK: Input: default@myinput1
    36. 

  36. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-34_705_7891360827662899707/-mr-10000
    37. 

  37. NULL	35	NULL	35
    38. 

  38. NULL	35	48	NULL
    39. 

  39. NULL	35	100	100
    40. 

  40. 48	NULL	NULL	35
    41. 

  41. 48	NULL	48	NULL
    42. 

  42. 48	NULL	100	100
    43. 

  43. 100	100	NULL	35
    44. 

  44. 100	100	48	NULL
    45. 

  45. 100	100	100	100
    46. 

  46. PREHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b
    47. 

  47. PREHOOK: type: QUERY
    48. 

  48. PREHOOK: Input: default@myinput1
    49. 

  49. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-37_744_4114021800417008700/-mr-10000
    50. 

  50. POSTHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b
    51. 

  51. POSTHOOK: type: QUERY
    52. 

  52. POSTHOOK: Input: default@myinput1
    53. 

  53. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-37_744_4114021800417008700/-mr-10000
    54. 

  54. NULL	35	NULL	35
    55. 

  55. NULL	35	48	NULL
    56. 

  56. NULL	35	100	100
    57. 

  57. 48	NULL	NULL	35
    58. 

  58. 48	NULL	48	NULL
    59. 

  59. 48	NULL	100	100
    60. 

  60. 100	100	NULL	35
    61. 

  61. 100	100	48	NULL
    62. 

  62. 100	100	100	100
    63. 

  63. PREHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.key = b.value
    64. 

  64. PREHOOK: type: QUERY
    65. 

  65. PREHOOK: Input: default@myinput1
    66. 

  66. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-40_759_3815040582770495358/-mr-10000
    67. 

  67. POSTHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.key = b.value
    68. 

  68. POSTHOOK: type: QUERY
    69. 

  69. POSTHOOK: Input: default@myinput1
    70. 

  70. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-40_759_3815040582770495358/-mr-10000
    71. 

  71. 100	100	100	100
    72. 

  72. PREHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.key = b.key
    73. 

  73. PREHOOK: type: QUERY
    74. 

  74. PREHOOK: Input: default@myinput1
    75. 

  75. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-43_808_2759732574228684621/-mr-10000
    76. 

  76. POSTHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.key = b.key
    77. 

  77. POSTHOOK: type: QUERY
    78. 

  78. POSTHOOK: Input: default@myinput1
    79. 

  79. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-43_808_2759732574228684621/-mr-10000
    80. 

  80. 48	NULL	48	NULL
    81. 

  81. 100	100	100	100
    82. 

  82. PREHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.value = b.value
    83. 

  83. PREHOOK: type: QUERY
    84. 

  84. PREHOOK: Input: default@myinput1
    85. 

  85. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-46_947_1207295790379918107/-mr-10000
    86. 

  86. POSTHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.value = b.value
    87. 

  87. POSTHOOK: type: QUERY
    88. 

  88. POSTHOOK: Input: default@myinput1
    89. 

  89. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-46_947_1207295790379918107/-mr-10000
    90. 

  90. NULL	35	NULL	35
    91. 

  91. 100	100	100	100
    92. 

  92. PREHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.value = b.value and a.key=b.key
    93. 

  93. PREHOOK: type: QUERY
    94. 

  94. PREHOOK: Input: default@myinput1
    95. 

  95. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-49_979_72536747155082974/-mr-10000
    96. 

  96. POSTHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.value = b.value and a.key=b.key
    97. 

  97. POSTHOOK: type: QUERY
    98. 

  98. POSTHOOK: Input: default@myinput1
    99. 

  99. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-49_979_72536747155082974/-mr-10000
    100. 

  100. 100	100	100	100
    101. 

  101. PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.value
    102. 

  102. PREHOOK: type: QUERY
    103. 

  103. PREHOOK: Input: default@myinput1
    104. 

  104. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-53_028_5270841162233231903/-mr-10000
    105. 

  105. POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.value
    106. 

  106. POSTHOOK: type: QUERY
    107. 

  107. POSTHOOK: Input: default@myinput1
    108. 

  108. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-53_028_5270841162233231903/-mr-10000
    109. 

  109. NULL	35	NULL	NULL
    110. 

  110. 48	NULL	NULL	NULL
    111. 

  111. 100	100	100	100
    112. 

  112. PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.value = b.value
    113. 

  113. PREHOOK: type: QUERY
    114. 

  114. PREHOOK: Input: default@myinput1
    115. 

  115. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-56_033_2563212770228159974/-mr-10000
    116. 

  116. POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.value = b.value
    117. 

  117. POSTHOOK: type: QUERY
    118. 

  118. POSTHOOK: Input: default@myinput1
    119. 

  119. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-56_033_2563212770228159974/-mr-10000
    120. 

  120. 48	NULL	NULL	NULL
    121. 

  121. NULL	35	NULL	35
    122. 

  122. 100	100	100	100
    123. 

  123. PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key
    124. 

  124. PREHOOK: type: QUERY
    125. 

  125. PREHOOK: Input: default@myinput1
    126. 

  126. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-59_098_2956450952074441661/-mr-10000
    127. 

  127. POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key
    128. 

  128. POSTHOOK: type: QUERY
    129. 

  129. POSTHOOK: Input: default@myinput1
    130. 

  130. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-59_098_2956450952074441661/-mr-10000
    131. 

  131. NULL	35	NULL	NULL
    132. 

  132. 48	NULL	48	NULL
    133. 

  133. 100	100	100	100
    134. 

  134. PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key and a.value=b.value
    135. 

  135. PREHOOK: type: QUERY
    136. 

  136. PREHOOK: Input: default@myinput1
    137. 

  137. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-02_499_2634558695451930427/-mr-10000
    138. 

  138. POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key and a.value=b.value
    139. 

  139. POSTHOOK: type: QUERY
    140. 

  140. POSTHOOK: Input: default@myinput1
    141. 

  141. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-02_499_2634558695451930427/-mr-10000
    142. 

  142. NULL	35	NULL	NULL
    143. 

  143. 48	NULL	NULL	NULL
    144. 

  144. 100	100	100	100
    145. 

  145. PREHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.value
    146. 

  146. PREHOOK: type: QUERY
    147. 

  147. PREHOOK: Input: default@myinput1
    148. 

  148. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-05_524_2948137722448172501/-mr-10000
    149. 

  149. POSTHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.value
    150. 

  150. POSTHOOK: type: QUERY
    151. 

  151. POSTHOOK: Input: default@myinput1
    152. 

  152. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-05_524_2948137722448172501/-mr-10000
    153. 

  153. NULL	NULL	48	NULL
    154. 

  154. NULL	NULL	NULL	35
    155. 

  155. 100	100	100	100
    156. 

  156. PREHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.key
    157. 

  157. PREHOOK: type: QUERY
    158. 

  158. PREHOOK: Input: default@myinput1
    159. 

  159. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-08_565_8758755781275848937/-mr-10000
    160. 

  160. POSTHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.key
    161. 

  161. POSTHOOK: type: QUERY
    162. 

  162. POSTHOOK: Input: default@myinput1
    163. 

  163. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-08_565_8758755781275848937/-mr-10000
    164. 

  164. NULL	NULL	NULL	35
    165. 

  165. 48	NULL	48	NULL
    166. 

  166. 100	100	100	100
    167. 

  167. PREHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.value = b.value
    168. 

  168. PREHOOK: type: QUERY
    169. 

  169. PREHOOK: Input: default@myinput1
    170. 

  170. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-11_597_4163684755001064006/-mr-10000
    171. 

  171. POSTHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.value = b.value
    172. 

  172. POSTHOOK: type: QUERY
    173. 

  173. POSTHOOK: Input: default@myinput1
    174. 

  174. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-11_597_4163684755001064006/-mr-10000
    175. 

  175. NULL	NULL	48	NULL
    176. 

  176. NULL	35	NULL	35
    177. 

  177. 100	100	100	100
    178. 

  178. PREHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key=b.key and a.value = b.value
    179. 

  179. PREHOOK: type: QUERY
    180. 

  180. PREHOOK: Input: default@myinput1
    181. 

  181. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-14_644_1473757744203304399/-mr-10000
    182. 

  182. POSTHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key=b.key and a.value = b.value
    183. 

  183. POSTHOOK: type: QUERY
    184. 

  184. POSTHOOK: Input: default@myinput1
    185. 

  185. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-14_644_1473757744203304399/-mr-10000
    186. 

  186. NULL	NULL	NULL	35
    187. 

  187. NULL	NULL	48	NULL
    188. 

  188. 100	100	100	100
    189. 

  189. PREHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.value
    190. 

  190. PREHOOK: type: QUERY
    191. 

  191. PREHOOK: Input: default@myinput1
    192. 

  192. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-17_701_3233060431500842705/-mr-10000
    193. 

  193. POSTHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.value
    194. 

  194. POSTHOOK: type: QUERY
    195. 

  195. POSTHOOK: Input: default@myinput1
    196. 

  196. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-17_701_3233060431500842705/-mr-10000
    197. 

  197. NULL	35	NULL	NULL
    198. 

  198. NULL	NULL	48	NULL
    199. 

  199. NULL	NULL	NULL	35
    200. 

  200. 48	NULL	NULL	NULL
    201. 

  201. 100	100	100	100
    202. 

  202. PREHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.key
    203. 

  203. PREHOOK: type: QUERY
    204. 

  204. PREHOOK: Input: default@myinput1
    205. 

  205. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-20_731_3400521495107335830/-mr-10000
    206. 

  206. POSTHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.key
    207. 

  207. POSTHOOK: type: QUERY
    208. 

  208. POSTHOOK: Input: default@myinput1
    209. 

  209. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-20_731_3400521495107335830/-mr-10000
    210. 

  210. NULL	35	NULL	NULL
    211. 

  211. NULL	NULL	NULL	35
    212. 

  212. 48	NULL	48	NULL
    213. 

  213. 100	100	100	100
    214. 

  214. PREHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value
    215. 

  215. PREHOOK: type: QUERY
    216. 

  216. PREHOOK: Input: default@myinput1
    217. 

  217. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-23_772_8205102532037513591/-mr-10000
    218. 

  218. POSTHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value
    219. 

  219. POSTHOOK: type: QUERY
    220. 

  220. POSTHOOK: Input: default@myinput1
    221. 

  221. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-23_772_8205102532037513591/-mr-10000
    222. 

  222. 48	NULL	NULL	NULL
    223. 

  223. NULL	NULL	48	NULL
    224. 

  224. NULL	35	NULL	35
    225. 

  225. 100	100	100	100
    226. 

  226. PREHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value and a.key=b.key
    227. 

  227. PREHOOK: type: QUERY
    228. 

  228. PREHOOK: Input: default@myinput1
    229. 

  229. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-26_795_2591262681463484422/-mr-10000
    230. 

  230. POSTHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value and a.key=b.key
    231. 

  231. POSTHOOK: type: QUERY
    232. 

  232. POSTHOOK: Input: default@myinput1
    233. 

  233. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-26_795_2591262681463484422/-mr-10000
    234. 

  234. 48	NULL	NULL	NULL
    235. 

  235. NULL	NULL	48	NULL
    236. 

  236. NULL	35	NULL	NULL
    237. 

  237. NULL	NULL	NULL	35
    238. 

  238. 100	100	100	100
    239. 

  239. PREHOOK: query: SELECT * from myinput1 a LEFT OUTER JOIN myinput1 b ON (a.value=b.value) RIGHT OUTER JOIN myinput1 c ON (b.value=c.value)
    240. 

  240. PREHOOK: type: QUERY
    241. 

  241. PREHOOK: Input: default@myinput1
    242. 

  242. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-29_952_3907129954364673344/-mr-10000
    243. 

  243. POSTHOOK: query: SELECT * from myinput1 a LEFT OUTER JOIN myinput1 b ON (a.value=b.value) RIGHT OUTER JOIN myinput1 c ON (b.value=c.value)
    244. 

  244. POSTHOOK: type: QUERY
    245. 

  245. POSTHOOK: Input: default@myinput1
    246. 

  246. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-29_952_3907129954364673344/-mr-10000
    247. 

  247. NULL	NULL	NULL	NULL	48	NULL
    248. 

  248. NULL	35	NULL	35	NULL	35
    249. 

  249. 100	100	100	100	100	100
    250. 

  250. PREHOOK: query: SELECT * from myinput1 a RIGHT OUTER JOIN myinput1 b ON (a.value=b.value) LEFT OUTER JOIN myinput1 c ON (b.value=c.value)
    251. 

  251. PREHOOK: type: QUERY
    252. 

  252. PREHOOK: Input: default@myinput1
    253. 

  253. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-33_142_6823602675610897415/-mr-10000
    254. 

  254. POSTHOOK: query: SELECT * from myinput1 a RIGHT OUTER JOIN myinput1 b ON (a.value=b.value) LEFT OUTER JOIN myinput1 c ON (b.value=c.value)
    255. 

  255. POSTHOOK: type: QUERY
    256. 

  256. POSTHOOK: Input: default@myinput1
    257. 

  257. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-33_142_6823602675610897415/-mr-10000
    258. 

  258. NULL	NULL	48	NULL	NULL	NULL
    259. 

  259. NULL	35	NULL	35	NULL	35
    260. 

  260. 100	100	100	100	100	100
    261. 

  261. PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b RIGHT OUTER JOIN myinput1 c ON a.value = b.value and b.value = c.value
    262. 

  262. PREHOOK: type: QUERY
    263. 

  263. PREHOOK: Input: default@myinput1
    264. 

  264. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-36_316_8421887369237695484/-mr-10000
    265. 

  265. POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b RIGHT OUTER JOIN myinput1 c ON a.value = b.value and b.value = c.value
    266. 

  266. POSTHOOK: type: QUERY
    267. 

  267. POSTHOOK: Input: default@myinput1
    268. 

  268. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-36_316_8421887369237695484/-mr-10000
    269. 

  269. NULL	NULL	NULL	NULL	48	NULL
    270. 

  270. NULL	35	NULL	35	NULL	35
    271. 

  271. 100	100	100	100	100	100
    272. 

  272. PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b
    273. 

  273. PREHOOK: type: QUERY
    274. 

  274. PREHOOK: Input: default@myinput1
    275. 

  275. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-42_314_7832502288070481455/-mr-10000
    276. 

  276. POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b
    277. 

  277. POSTHOOK: type: QUERY
    278. 

  278. POSTHOOK: Input: default@myinput1
    279. 

  279. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-42_314_7832502288070481455/-mr-10000
    280. 

  280. NULL	35	NULL	35
    281. 

  281. 48	NULL	NULL	35
    282. 

  282. 100	100	NULL	35
    283. 

  283. NULL	35	48	NULL
    284. 

  284. 48	NULL	48	NULL
    285. 

  285. 100	100	48	NULL
    286. 

  286. NULL	35	100	100
    287. 

  287. 48	NULL	100	100
    288. 

  288. 100	100	100	100
    289. 

  289. PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.value
    290. 

  290. PREHOOK: type: QUERY
    291. 

  291. PREHOOK: Input: default@myinput1
    292. 

  292. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-46_762_6120606337889646190/-mr-10000
    293. 

  293. POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.value
    294. 

  294. POSTHOOK: type: QUERY
    295. 

  295. POSTHOOK: Input: default@myinput1
    296. 

  296. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-46_762_6120606337889646190/-mr-10000
    297. 

  297. 100	100	100	100
    298. 

  298. PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.key
    299. 

  299. PREHOOK: type: QUERY
    300. 

  300. PREHOOK: Input: default@myinput1
    301. 

  301. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-51_044_4003336790967485394/-mr-10000
    302. 

  302. POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.key
    303. 

  303. POSTHOOK: type: QUERY
    304. 

  304. POSTHOOK: Input: default@myinput1
    305. 

  305. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-51_044_4003336790967485394/-mr-10000
    306. 

  306. 48	NULL	48	NULL
    307. 

  307. 100	100	100	100
    308. 

  308. PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value
    309. 

  309. PREHOOK: type: QUERY
    310. 

  310. PREHOOK: Input: default@myinput1
    311. 

  311. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-55_518_3112283007132020008/-mr-10000
    312. 

  312. POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value
    313. 

  313. POSTHOOK: type: QUERY
    314. 

  314. POSTHOOK: Input: default@myinput1
    315. 

  315. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-55_518_3112283007132020008/-mr-10000
    316. 

  316. NULL	35	NULL	35
    317. 

  317. 100	100	100	100
    318. 

  318. PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.value
    319. 

  319. PREHOOK: type: QUERY
    320. 

  320. PREHOOK: Input: default@myinput1
    321. 

  321. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-59_949_5790066510806491529/-mr-10000
    322. 

  322. POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.value
    323. 

  323. POSTHOOK: type: QUERY
    324. 

  324. POSTHOOK: Input: default@myinput1
    325. 

  325. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-59_949_5790066510806491529/-mr-10000
    326. 

  326. 100	100	100	100
    327. 

  327. PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.key
    328. 

  328. PREHOOK: type: QUERY
    329. 

  329. PREHOOK: Input: default@myinput1
    330. 

  330. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-04_795_2786006750968345680/-mr-10000
    331. 

  331. POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.key
    332. 

  332. POSTHOOK: type: QUERY
    333. 

  333. POSTHOOK: Input: default@myinput1
    334. 

  334. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-04_795_2786006750968345680/-mr-10000
    335. 

  335. 48	NULL	48	NULL
    336. 

  336. 100	100	100	100
    337. 

  337. PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value
    338. 

  338. PREHOOK: type: QUERY
    339. 

  339. PREHOOK: Input: default@myinput1
    340. 

  340. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-09_243_7699519116048493679/-mr-10000
    341. 

  341. POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value
    342. 

  342. POSTHOOK: type: QUERY
    343. 

  343. POSTHOOK: Input: default@myinput1
    344. 

  344. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-09_243_7699519116048493679/-mr-10000
    345. 

  345. NULL	35	NULL	35
    346. 

  346. 100	100	100	100
    347. 

  347. PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value and a.key = b.key
    348. 

  348. PREHOOK: type: QUERY
    349. 

  349. PREHOOK: Input: default@myinput1
    350. 

  350. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-13_641_5006098680854899312/-mr-10000
    351. 

  351. POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value and a.key = b.key
    352. 

  352. POSTHOOK: type: QUERY
    353. 

  353. POSTHOOK: Input: default@myinput1
    354. 

  354. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-13_641_5006098680854899312/-mr-10000
    355. 

  355. 100	100	100	100
    356. 

  356. PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.value
    357. 

  357. PREHOOK: type: QUERY
    358. 

  358. PREHOOK: Input: default@myinput1
    359. 

  359. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-18_040_7373396463499323566/-mr-10000
    360. 

  360. POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.value
    361. 

  361. POSTHOOK: type: QUERY
    362. 

  362. POSTHOOK: Input: default@myinput1
    363. 

  363. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-18_040_7373396463499323566/-mr-10000
    364. 

  364. NULL	35	NULL	NULL
    365. 

  365. 48	NULL	NULL	NULL
    366. 

  366. 100	100	100	100
    367. 

  367. PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key
    368. 

  368. PREHOOK: type: QUERY
    369. 

  369. PREHOOK: Input: default@myinput1
    370. 

  370. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-22_447_6328039718202844843/-mr-10000
    371. 

  371. POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key
    372. 

  372. POSTHOOK: type: QUERY
    373. 

  373. POSTHOOK: Input: default@myinput1
    374. 

  374. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-22_447_6328039718202844843/-mr-10000
    375. 

  375. NULL	35	NULL	NULL
    376. 

  376. 48	NULL	48	NULL
    377. 

  377. 100	100	100	100
    378. 

  378. PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.value = b.value
    379. 

  379. PREHOOK: type: QUERY
    380. 

  380. PREHOOK: Input: default@myinput1
    381. 

  381. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-26_837_6878002404083813297/-mr-10000
    382. 

  382. POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.value = b.value
    383. 

  383. POSTHOOK: type: QUERY
    384. 

  384. POSTHOOK: Input: default@myinput1
    385. 

  385. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-26_837_6878002404083813297/-mr-10000
    386. 

  386. NULL	35	NULL	35
    387. 

  387. 48	NULL	NULL	NULL
    388. 

  388. 100	100	100	100
    389. 

  389. PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.value
    390. 

  390. PREHOOK: type: QUERY
    391. 

  391. PREHOOK: Input: default@myinput1
    392. 

  392. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-31_327_4809407974402234126/-mr-10000
    393. 

  393. POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.value
    394. 

  394. POSTHOOK: type: QUERY
    395. 

  395. POSTHOOK: Input: default@myinput1
    396. 

  396. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-31_327_4809407974402234126/-mr-10000
    397. 

  397. NULL	NULL	NULL	35
    398. 

  398. NULL	NULL	48	NULL
    399. 

  399. 100	100	100	100
    400. 

  400. PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.key
    401. 

  401. PREHOOK: type: QUERY
    402. 

  402. PREHOOK: Input: default@myinput1
    403. 

  403. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-35_742_1654943644282955382/-mr-10000
    404. 

  404. POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.key
    405. 

  405. POSTHOOK: type: QUERY
    406. 

  406. POSTHOOK: Input: default@myinput1
    407. 

  407. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-35_742_1654943644282955382/-mr-10000
    408. 

  408. NULL	NULL	NULL	35
    409. 

  409. 48	NULL	48	NULL
    410. 

  410. 100	100	100	100
    411. 

  411. PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.value = b.value
    412. 

  412. PREHOOK: type: QUERY
    413. 

  413. PREHOOK: Input: default@myinput1
    414. 

  414. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-40_216_7170971377841192858/-mr-10000
    415. 

  415. POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.value = b.value
    416. 

  416. POSTHOOK: type: QUERY
    417. 

  417. POSTHOOK: Input: default@myinput1
    418. 

  418. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-40_216_7170971377841192858/-mr-10000
    419. 

  419. NULL	35	NULL	35
    420. 

  420. NULL	NULL	48	NULL
    421. 

  421. 100	100	100	100
    422. 

  422. PREHOOK: query: CREATE TABLE smb_input1(key int, value int) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
    423. 

  423. PREHOOK: type: CREATETABLE
    424. 

  424. POSTHOOK: query: CREATE TABLE smb_input1(key int, value int) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
    425. 

  425. POSTHOOK: type: CREATETABLE
    426. 

  426. POSTHOOK: Output: default@smb_input1
    427. 

  427. PREHOOK: query: CREATE TABLE smb_input2(key int, value int) CLUSTERED BY (value) SORTED BY (value) INTO 2 BUCKETS
    428. 

  428. PREHOOK: type: CREATETABLE
    429. 

  429. POSTHOOK: query: CREATE TABLE smb_input2(key int, value int) CLUSTERED BY (value) SORTED BY (value) INTO 2 BUCKETS
    430. 

  430. POSTHOOK: type: CREATETABLE
    431. 

  431. POSTHOOK: Output: default@smb_input2
    432. 

  432. PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in1.txt' into table smb_input1
    433. 

  433. PREHOOK: type: LOAD
    434. 

  434. PREHOOK: Output: default@smb_input1
    435. 

  435. POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in1.txt' into table smb_input1
    436. 

  436. POSTHOOK: type: LOAD
    437. 

  437. POSTHOOK: Output: default@smb_input1
    438. 

  438. PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in2.txt' into table smb_input1
    439. 

  439. PREHOOK: type: LOAD
    440. 

  440. PREHOOK: Output: default@smb_input1
    441. 

  441. POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in2.txt' into table smb_input1
    442. 

  442. POSTHOOK: type: LOAD
    443. 

  443. POSTHOOK: Output: default@smb_input1
    444. 

  444. PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in1.txt' into table smb_input2
    445. 

  445. PREHOOK: type: LOAD
    446. 

  446. PREHOOK: Output: default@smb_input2
    447. 

  447. POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in1.txt' into table smb_input2
    448. 

  448. POSTHOOK: type: LOAD
    449. 

  449. POSTHOOK: Output: default@smb_input2
    450. 

  450. PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in2.txt' into table smb_input2
    451. 

  451. PREHOOK: type: LOAD
    452. 

  452. PREHOOK: Output: default@smb_input2
    453. 

  453. POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in2.txt' into table smb_input2
    454. 

  454. POSTHOOK: type: LOAD
    455. 

  455. POSTHOOK: Output: default@smb_input2
    456. 

  456. PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key = b.key ORDER BY a.key
    457. 

  457. PREHOOK: type: QUERY
    458. 

  458. PREHOOK: Input: default@smb_input1
    459. 

  459. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-45_071_1721369920851863145/-mr-10000
    460. 

  460. POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key = b.key ORDER BY a.key
    461. 

  461. POSTHOOK: type: QUERY
    462. 

  462. POSTHOOK: Input: default@smb_input1
    463. 

  463. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-45_071_1721369920851863145/-mr-10000
    464. 

  464. 48	NULL	48	NULL
    465. 

  465. 100	100	100	100
    466. 

  466. 148	NULL	148	NULL
    467. 

  467. 200	200	200	200
    468. 

  468. PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key = b.key AND a.value = b.value ORDER BY a.key
    469. 

  469. PREHOOK: type: QUERY
    470. 

  470. PREHOOK: Input: default@smb_input1
    471. 

  471. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-52_288_5442108787449062892/-mr-10000
    472. 

  472. POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key = b.key AND a.value = b.value ORDER BY a.key
    473. 

  473. POSTHOOK: type: QUERY
    474. 

  474. POSTHOOK: Input: default@smb_input1
    475. 

  475. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-52_288_5442108787449062892/-mr-10000
    476. 

  476. 100	100	100	100
    477. 

  477. 200	200	200	200
    478. 

  478. PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a RIGHT OUTER JOIN smb_input1 b ON a.key = b.key ORDER BY b.key, b.value
    479. 

  479. PREHOOK: type: QUERY
    480. 

  480. PREHOOK: Input: default@smb_input1
    481. 

  481. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-59_488_9220251315068456695/-mr-10000
    482. 

  482. POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a RIGHT OUTER JOIN smb_input1 b ON a.key = b.key ORDER BY b.key, b.value
    483. 

  483. POSTHOOK: type: QUERY
    484. 

  484. POSTHOOK: Input: default@smb_input1
    485. 

  485. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-59_488_9220251315068456695/-mr-10000
    486. 

  486. NULL	NULL	NULL	35
    487. 

  487. NULL	NULL	NULL	135
    488. 

  488. 48	NULL	48	NULL
    489. 

  489. 100	100	100	100
    490. 

  490. 148	NULL	148	NULL
    491. 

  491. 200	200	200	200
    492. 

  492. PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key = b.key ORDER BY a.key
    493. 

  493. PREHOOK: type: QUERY
    494. 

  494. PREHOOK: Input: default@smb_input1
    495. 

  495. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-06_798_1515908496616104358/-mr-10000
    496. 

  496. POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key = b.key ORDER BY a.key
    497. 

  497. POSTHOOK: type: QUERY
    498. 

  498. POSTHOOK: Input: default@smb_input1
    499. 

  499. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-06_798_1515908496616104358/-mr-10000
    500. 

  500. 48	NULL	48	NULL
    501. 

  501. 100	100	100	100
    502. 

  502. 148	NULL	148	NULL
    503. 

  503. 200	200	200	200
    504. 

  504. PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a LEFT OUTER JOIN smb_input1 b ON a.key = b.key ORDER BY a.key, a.value
    505. 

  505. PREHOOK: type: QUERY
    506. 

  506. PREHOOK: Input: default@smb_input1
    507. 

  507. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-13_978_37675414267460205/-mr-10000
    508. 

  508. POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a LEFT OUTER JOIN smb_input1 b ON a.key = b.key ORDER BY a.key, a.value
    509. 

  509. POSTHOOK: type: QUERY
    510. 

  510. POSTHOOK: Input: default@smb_input1
    511. 

  511. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-13_978_37675414267460205/-mr-10000
    512. 

  512. NULL	35	NULL	NULL
    513. 

  513. NULL	135	NULL	NULL
    514. 

  514. 48	NULL	48	NULL
    515. 

  515. 100	100	100	100
    516. 

  516. 148	NULL	148	NULL
    517. 

  517. 200	200	200	200
    518. 

  518. PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN smb_input2 b ON a.key = b.value ORDER BY a.key
    519. 

  519. PREHOOK: type: QUERY
    520. 

  520. PREHOOK: Input: default@smb_input1
    521. 

  521. PREHOOK: Input: default@smb_input2
    522. 

  522. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-21_231_8292843591044391733/-mr-10000
    523. 

  523. POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN smb_input2 b ON a.key = b.value ORDER BY a.key
    524. 

  524. POSTHOOK: type: QUERY
    525. 

  525. POSTHOOK: Input: default@smb_input1
    526. 

  526. POSTHOOK: Input: default@smb_input2
    527. 

  527. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-21_231_8292843591044391733/-mr-10000
    528. 

  528. 100	100	100	100
    529. 

  529. 200	200	200	200
    530. 

  530. PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a JOIN smb_input2 b ON a.key = b.value ORDER BY a.key
    531. 

  531. PREHOOK: type: QUERY
    532. 

  532. PREHOOK: Input: default@smb_input1
    533. 

  533. PREHOOK: Input: default@smb_input2
    534. 

  534. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-28_835_6286309168082618901/-mr-10000
    535. 

  535. POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a JOIN smb_input2 b ON a.key = b.value ORDER BY a.key
    536. 

  536. POSTHOOK: type: QUERY
    537. 

  537. POSTHOOK: Input: default@smb_input1
    538. 

  538. POSTHOOK: Input: default@smb_input2
    539. 

  539. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-28_835_6286309168082618901/-mr-10000
    540. 

  540. 100	100	100	100
    541. 

  541. 200	200	200	200
    542. 

  542. PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a LEFT OUTER JOIN smb_input2 b ON a.key = b.value ORDER BY a.key, a.value
    543. 

  543. PREHOOK: type: QUERY
    544. 

  544. PREHOOK: Input: default@smb_input1
    545. 

  545. PREHOOK: Input: default@smb_input2
    546. 

  546. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-36_026_7352279404756888950/-mr-10000
    547. 

  547. POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a LEFT OUTER JOIN smb_input2 b ON a.key = b.value ORDER BY a.key, a.value
    548. 

  548. POSTHOOK: type: QUERY
    549. 

  549. POSTHOOK: Input: default@smb_input1
    550. 

  550. POSTHOOK: Input: default@smb_input2
    551. 

  551. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-36_026_7352279404756888950/-mr-10000
    552. 

  552. NULL	35	NULL	NULL
    553. 

  553. NULL	135	NULL	NULL
    554. 

  554. 48	NULL	NULL	NULL
    555. 

  555. 100	100	100	100
    556. 

  556. 148	NULL	NULL	NULL
    557. 

  557. 200	200	200	200
    558. 

  558. PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a RIGHT OUTER JOIN smb_input2 b ON a.key = b.value ORDER BY b.key, b.value
    559. 

  559. PREHOOK: type: QUERY
    560. 

  560. PREHOOK: Input: default@smb_input1
    561. 

  561. PREHOOK: Input: default@smb_input2
    562. 

  562. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-43_251_628261964080538715/-mr-10000
    563. 

  563. POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a RIGHT OUTER JOIN smb_input2 b ON a.key = b.value ORDER BY b.key, b.value
    564. 

  564. POSTHOOK: type: QUERY
    565. 

  565. POSTHOOK: Input: default@smb_input1
    566. 

  566. POSTHOOK: Input: default@smb_input2
    567. 

  567. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-43_251_628261964080538715/-mr-10000
    568. 

  568. NULL	NULL	NULL	35
    569. 

  569. NULL	NULL	NULL	135
    570. 

  570. NULL	NULL	48	NULL
    571. 

  571. 100	100	100	100
    572. 

  572. NULL	NULL	148	NULL
    573. 

  573. 200	200	200	200
    574. 

  574. PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input2 a JOIN smb_input2 b ON a.value = b.value ORDER BY a.value
    575. 

  575. PREHOOK: type: QUERY
    576. 

  576. PREHOOK: Input: default@smb_input2
    577. 

  577. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-50_368_3840876669646785753/-mr-10000
    578. 

  578. POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input2 a JOIN smb_input2 b ON a.value = b.value ORDER BY a.value
    579. 

  579. POSTHOOK: type: QUERY
    580. 

  580. POSTHOOK: Input: default@smb_input2
    581. 

  581. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-50_368_3840876669646785753/-mr-10000
    582. 

  582. NULL	35	NULL	35
    583. 

  583. 100	100	100	100
    584. 

  584. NULL	135	NULL	135
    585. 

  585. 200	200	200	200
    586. 

  586. PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input2 a RIGHT OUTER JOIN smb_input2 b ON a.value = b.value ORDER BY b.key, b.value
    587. 

  587. PREHOOK: type: QUERY
    588. 

  588. PREHOOK: Input: default@smb_input2
    589. 

  589. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-57_464_1575904257589847287/-mr-10000
    590. 

  590. POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input2 a RIGHT OUTER JOIN smb_input2 b ON a.value = b.value ORDER BY b.key, b.value
    591. 

  591. POSTHOOK: type: QUERY
    592. 

  592. POSTHOOK: Input: default@smb_input2
    593. 

  593. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-57_464_1575904257589847287/-mr-10000
    594. 

  594. NULL	35	NULL	35
    595. 

  595. NULL	135	NULL	135
    596. 

  596. NULL	NULL	48	NULL
    597. 

  597. 100	100	100	100
    598. 

  598. NULL	NULL	148	NULL
    599. 

  599. 200	200	200	200
    600. 

  600. PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input2 a JOIN smb_input2 b ON a.value = b.value ORDER BY a.value
    601. 

  601. PREHOOK: type: QUERY
    602. 

  602. PREHOOK: Input: default@smb_input2
    603. 

  603. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-57-04_710_6771480365280106011/-mr-10000
    604. 

  604. POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input2 a JOIN smb_input2 b ON a.value = b.value ORDER BY a.value
    605. 

  605. POSTHOOK: type: QUERY
    606. 

  606. POSTHOOK: Input: default@smb_input2
    607. 

  607. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-57-04_710_6771480365280106011/-mr-10000
    608. 

  608. NULL	35	NULL	35
    609. 

  609. 100	100	100	100
    610. 

  610. NULL	135	NULL	135
    611. 

  611. 200	200	200	200
    612. 

  612. PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input2 a LEFT OUTER JOIN smb_input2 b ON a.value = b.value ORDER BY a.key, a.value
    613. 

  613. PREHOOK: type: QUERY
    614. 

  614. PREHOOK: Input: default@smb_input2
    615. 

  615. PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-57-11_842_9028034862567967736/-mr-10000
    616. 

  616. POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input2 a LEFT OUTER JOIN smb_input2 b ON a.value = b.value ORDER BY a.key, a.value
    617. 

  617. POSTHOOK: type: QUERY
    618. 

  618. POSTHOOK: Input: default@smb_input2
    619. 

  619. POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-57-11_842_9028034862567967736/-mr-10000
    620. 

  620. NULL	35	NULL	35
    621. 

  621. NULL	135	NULL	135
    622. 

  622. 48	NULL	NULL	NULL
    623. 

  623. 100	100	100	100
    624. 

  624. 148	NULL	NULL	NULL
    625. 

  625. 200	200	200	200
    626. 

  626.