PageRenderTime 12ms CodeModel.GetById 2ms app.highlight 6ms RepoModel.GetById 1ms 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
  1PREHOOK: query: CREATE TABLE myinput1(key int, value int)
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: CREATE TABLE myinput1(key int, value int)
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@myinput1
  6PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in1.txt' INTO TABLE myinput1
  7PREHOOK: type: LOAD
  8PREHOOK: Output: default@myinput1
  9POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in1.txt' INTO TABLE myinput1
 10POSTHOOK: type: LOAD
 11POSTHOOK: Output: default@myinput1
 12PREHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b
 13PREHOOK: type: QUERY
 14PREHOOK: Input: default@myinput1
 15PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-31_683_8641177538651570201/-mr-10000
 16POSTHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b
 17POSTHOOK: type: QUERY
 18POSTHOOK: Input: default@myinput1
 19POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-31_683_8641177538651570201/-mr-10000
 20NULL	35	NULL	35
 21NULL	35	48	NULL
 22NULL	35	100	100
 2348	NULL	NULL	35
 2448	NULL	48	NULL
 2548	NULL	100	100
 26100	100	NULL	35
 27100	100	48	NULL
 28100	100	100	100
 29PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b
 30PREHOOK: type: QUERY
 31PREHOOK: Input: default@myinput1
 32PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-34_705_7891360827662899707/-mr-10000
 33POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b
 34POSTHOOK: type: QUERY
 35POSTHOOK: Input: default@myinput1
 36POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-34_705_7891360827662899707/-mr-10000
 37NULL	35	NULL	35
 38NULL	35	48	NULL
 39NULL	35	100	100
 4048	NULL	NULL	35
 4148	NULL	48	NULL
 4248	NULL	100	100
 43100	100	NULL	35
 44100	100	48	NULL
 45100	100	100	100
 46PREHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b
 47PREHOOK: type: QUERY
 48PREHOOK: Input: default@myinput1
 49PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-37_744_4114021800417008700/-mr-10000
 50POSTHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b
 51POSTHOOK: type: QUERY
 52POSTHOOK: Input: default@myinput1
 53POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-37_744_4114021800417008700/-mr-10000
 54NULL	35	NULL	35
 55NULL	35	48	NULL
 56NULL	35	100	100
 5748	NULL	NULL	35
 5848	NULL	48	NULL
 5948	NULL	100	100
 60100	100	NULL	35
 61100	100	48	NULL
 62100	100	100	100
 63PREHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.key = b.value
 64PREHOOK: type: QUERY
 65PREHOOK: Input: default@myinput1
 66PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-40_759_3815040582770495358/-mr-10000
 67POSTHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.key = b.value
 68POSTHOOK: type: QUERY
 69POSTHOOK: Input: default@myinput1
 70POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-40_759_3815040582770495358/-mr-10000
 71100	100	100	100
 72PREHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.key = b.key
 73PREHOOK: type: QUERY
 74PREHOOK: Input: default@myinput1
 75PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-43_808_2759732574228684621/-mr-10000
 76POSTHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.key = b.key
 77POSTHOOK: type: QUERY
 78POSTHOOK: Input: default@myinput1
 79POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-43_808_2759732574228684621/-mr-10000
 8048	NULL	48	NULL
 81100	100	100	100
 82PREHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.value = b.value
 83PREHOOK: type: QUERY
 84PREHOOK: Input: default@myinput1
 85PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-46_947_1207295790379918107/-mr-10000
 86POSTHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.value = b.value
 87POSTHOOK: type: QUERY
 88POSTHOOK: Input: default@myinput1
 89POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-46_947_1207295790379918107/-mr-10000
 90NULL	35	NULL	35
 91100	100	100	100
 92PREHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.value = b.value and a.key=b.key
 93PREHOOK: type: QUERY
 94PREHOOK: Input: default@myinput1
 95PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-49_979_72536747155082974/-mr-10000
 96POSTHOOK: query: SELECT * FROM myinput1 a JOIN myinput1 b ON a.value = b.value and a.key=b.key
 97POSTHOOK: type: QUERY
 98POSTHOOK: Input: default@myinput1
 99POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-49_979_72536747155082974/-mr-10000
100100	100	100	100
101PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.value
102PREHOOK: type: QUERY
103PREHOOK: Input: default@myinput1
104PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-53_028_5270841162233231903/-mr-10000
105POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.value
106POSTHOOK: type: QUERY
107POSTHOOK: Input: default@myinput1
108POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-53_028_5270841162233231903/-mr-10000
109NULL	35	NULL	NULL
11048	NULL	NULL	NULL
111100	100	100	100
112PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.value = b.value
113PREHOOK: type: QUERY
114PREHOOK: Input: default@myinput1
115PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-56_033_2563212770228159974/-mr-10000
116POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.value = b.value
117POSTHOOK: type: QUERY
118POSTHOOK: Input: default@myinput1
119POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-56_033_2563212770228159974/-mr-10000
12048	NULL	NULL	NULL
121NULL	35	NULL	35
122100	100	100	100
123PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key
124PREHOOK: type: QUERY
125PREHOOK: Input: default@myinput1
126PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-59_098_2956450952074441661/-mr-10000
127POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key
128POSTHOOK: type: QUERY
129POSTHOOK: Input: default@myinput1
130POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-53-59_098_2956450952074441661/-mr-10000
131NULL	35	NULL	NULL
13248	NULL	48	NULL
133100	100	100	100
134PREHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key and a.value=b.value
135PREHOOK: type: QUERY
136PREHOOK: Input: default@myinput1
137PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-02_499_2634558695451930427/-mr-10000
138POSTHOOK: query: SELECT * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key and a.value=b.value
139POSTHOOK: type: QUERY
140POSTHOOK: Input: default@myinput1
141POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-02_499_2634558695451930427/-mr-10000
142NULL	35	NULL	NULL
14348	NULL	NULL	NULL
144100	100	100	100
145PREHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.value
146PREHOOK: type: QUERY
147PREHOOK: Input: default@myinput1
148PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-05_524_2948137722448172501/-mr-10000
149POSTHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.value
150POSTHOOK: type: QUERY
151POSTHOOK: Input: default@myinput1
152POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-05_524_2948137722448172501/-mr-10000
153NULL	NULL	48	NULL
154NULL	NULL	NULL	35
155100	100	100	100
156PREHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.key
157PREHOOK: type: QUERY
158PREHOOK: Input: default@myinput1
159PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-08_565_8758755781275848937/-mr-10000
160POSTHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.key
161POSTHOOK: type: QUERY
162POSTHOOK: Input: default@myinput1
163POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-08_565_8758755781275848937/-mr-10000
164NULL	NULL	NULL	35
16548	NULL	48	NULL
166100	100	100	100
167PREHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.value = b.value
168PREHOOK: type: QUERY
169PREHOOK: Input: default@myinput1
170PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-11_597_4163684755001064006/-mr-10000
171POSTHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.value = b.value
172POSTHOOK: type: QUERY
173POSTHOOK: Input: default@myinput1
174POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-11_597_4163684755001064006/-mr-10000
175NULL	NULL	48	NULL
176NULL	35	NULL	35
177100	100	100	100
178PREHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key=b.key and a.value = b.value
179PREHOOK: type: QUERY
180PREHOOK: Input: default@myinput1
181PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-14_644_1473757744203304399/-mr-10000
182POSTHOOK: query: SELECT * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key=b.key and a.value = b.value
183POSTHOOK: type: QUERY
184POSTHOOK: Input: default@myinput1
185POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-14_644_1473757744203304399/-mr-10000
186NULL	NULL	NULL	35
187NULL	NULL	48	NULL
188100	100	100	100
189PREHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.value
190PREHOOK: type: QUERY
191PREHOOK: Input: default@myinput1
192PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-17_701_3233060431500842705/-mr-10000
193POSTHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.value
194POSTHOOK: type: QUERY
195POSTHOOK: Input: default@myinput1
196POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-17_701_3233060431500842705/-mr-10000
197NULL	35	NULL	NULL
198NULL	NULL	48	NULL
199NULL	NULL	NULL	35
20048	NULL	NULL	NULL
201100	100	100	100
202PREHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.key
203PREHOOK: type: QUERY
204PREHOOK: Input: default@myinput1
205PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-20_731_3400521495107335830/-mr-10000
206POSTHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.key = b.key
207POSTHOOK: type: QUERY
208POSTHOOK: Input: default@myinput1
209POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-20_731_3400521495107335830/-mr-10000
210NULL	35	NULL	NULL
211NULL	NULL	NULL	35
21248	NULL	48	NULL
213100	100	100	100
214PREHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value
215PREHOOK: type: QUERY
216PREHOOK: Input: default@myinput1
217PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-23_772_8205102532037513591/-mr-10000
218POSTHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value
219POSTHOOK: type: QUERY
220POSTHOOK: Input: default@myinput1
221POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-23_772_8205102532037513591/-mr-10000
22248	NULL	NULL	NULL
223NULL	NULL	48	NULL
224NULL	35	NULL	35
225100	100	100	100
226PREHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value and a.key=b.key
227PREHOOK: type: QUERY
228PREHOOK: Input: default@myinput1
229PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-26_795_2591262681463484422/-mr-10000
230POSTHOOK: query: SELECT * FROM myinput1 a FULL OUTER JOIN myinput1 b ON a.value = b.value and a.key=b.key
231POSTHOOK: type: QUERY
232POSTHOOK: Input: default@myinput1
233POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-26_795_2591262681463484422/-mr-10000
23448	NULL	NULL	NULL
235NULL	NULL	48	NULL
236NULL	35	NULL	NULL
237NULL	NULL	NULL	35
238100	100	100	100
239PREHOOK: 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)
240PREHOOK: type: QUERY
241PREHOOK: Input: default@myinput1
242PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-29_952_3907129954364673344/-mr-10000
243POSTHOOK: 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)
244POSTHOOK: type: QUERY
245POSTHOOK: Input: default@myinput1
246POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-29_952_3907129954364673344/-mr-10000
247NULL	NULL	NULL	NULL	48	NULL
248NULL	35	NULL	35	NULL	35
249100	100	100	100	100	100
250PREHOOK: 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)
251PREHOOK: type: QUERY
252PREHOOK: Input: default@myinput1
253PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-33_142_6823602675610897415/-mr-10000
254POSTHOOK: 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)
255POSTHOOK: type: QUERY
256POSTHOOK: Input: default@myinput1
257POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-33_142_6823602675610897415/-mr-10000
258NULL	NULL	48	NULL	NULL	NULL
259NULL	35	NULL	35	NULL	35
260100	100	100	100	100	100
261PREHOOK: 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
262PREHOOK: type: QUERY
263PREHOOK: Input: default@myinput1
264PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-36_316_8421887369237695484/-mr-10000
265POSTHOOK: 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
266POSTHOOK: type: QUERY
267POSTHOOK: Input: default@myinput1
268POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-36_316_8421887369237695484/-mr-10000
269NULL	NULL	NULL	NULL	48	NULL
270NULL	35	NULL	35	NULL	35
271100	100	100	100	100	100
272PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b
273PREHOOK: type: QUERY
274PREHOOK: Input: default@myinput1
275PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-42_314_7832502288070481455/-mr-10000
276POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b
277POSTHOOK: type: QUERY
278POSTHOOK: Input: default@myinput1
279POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-42_314_7832502288070481455/-mr-10000
280NULL	35	NULL	35
28148	NULL	NULL	35
282100	100	NULL	35
283NULL	35	48	NULL
28448	NULL	48	NULL
285100	100	48	NULL
286NULL	35	100	100
28748	NULL	100	100
288100	100	100	100
289PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.value
290PREHOOK: type: QUERY
291PREHOOK: Input: default@myinput1
292PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-46_762_6120606337889646190/-mr-10000
293POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.value
294POSTHOOK: type: QUERY
295POSTHOOK: Input: default@myinput1
296POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-46_762_6120606337889646190/-mr-10000
297100	100	100	100
298PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.key
299PREHOOK: type: QUERY
300PREHOOK: Input: default@myinput1
301PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-51_044_4003336790967485394/-mr-10000
302POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.key
303POSTHOOK: type: QUERY
304POSTHOOK: Input: default@myinput1
305POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-51_044_4003336790967485394/-mr-10000
30648	NULL	48	NULL
307100	100	100	100
308PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value
309PREHOOK: type: QUERY
310PREHOOK: Input: default@myinput1
311PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-55_518_3112283007132020008/-mr-10000
312POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value
313POSTHOOK: type: QUERY
314POSTHOOK: Input: default@myinput1
315POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-55_518_3112283007132020008/-mr-10000
316NULL	35	NULL	35
317100	100	100	100
318PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.value
319PREHOOK: type: QUERY
320PREHOOK: Input: default@myinput1
321PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-59_949_5790066510806491529/-mr-10000
322POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.value
323POSTHOOK: type: QUERY
324POSTHOOK: Input: default@myinput1
325POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-54-59_949_5790066510806491529/-mr-10000
326100	100	100	100
327PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.key
328PREHOOK: type: QUERY
329PREHOOK: Input: default@myinput1
330PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-04_795_2786006750968345680/-mr-10000
331POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.key = b.key
332POSTHOOK: type: QUERY
333POSTHOOK: Input: default@myinput1
334POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-04_795_2786006750968345680/-mr-10000
33548	NULL	48	NULL
336100	100	100	100
337PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value
338PREHOOK: type: QUERY
339PREHOOK: Input: default@myinput1
340PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-09_243_7699519116048493679/-mr-10000
341POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value
342POSTHOOK: type: QUERY
343POSTHOOK: Input: default@myinput1
344POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-09_243_7699519116048493679/-mr-10000
345NULL	35	NULL	35
346100	100	100	100
347PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value and a.key = b.key
348PREHOOK: type: QUERY
349PREHOOK: Input: default@myinput1
350PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-13_641_5006098680854899312/-mr-10000
351POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN myinput1 b ON a.value = b.value and a.key = b.key
352POSTHOOK: type: QUERY
353POSTHOOK: Input: default@myinput1
354POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-13_641_5006098680854899312/-mr-10000
355100	100	100	100
356PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.value
357PREHOOK: type: QUERY
358PREHOOK: Input: default@myinput1
359PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-18_040_7373396463499323566/-mr-10000
360POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.value
361POSTHOOK: type: QUERY
362POSTHOOK: Input: default@myinput1
363POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-18_040_7373396463499323566/-mr-10000
364NULL	35	NULL	NULL
36548	NULL	NULL	NULL
366100	100	100	100
367PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key
368PREHOOK: type: QUERY
369PREHOOK: Input: default@myinput1
370PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-22_447_6328039718202844843/-mr-10000
371POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.key = b.key
372POSTHOOK: type: QUERY
373POSTHOOK: Input: default@myinput1
374POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-22_447_6328039718202844843/-mr-10000
375NULL	35	NULL	NULL
37648	NULL	48	NULL
377100	100	100	100
378PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.value = b.value
379PREHOOK: type: QUERY
380PREHOOK: Input: default@myinput1
381PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-26_837_6878002404083813297/-mr-10000
382POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON a.value = b.value
383POSTHOOK: type: QUERY
384POSTHOOK: Input: default@myinput1
385POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-26_837_6878002404083813297/-mr-10000
386NULL	35	NULL	35
38748	NULL	NULL	NULL
388100	100	100	100
389PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.value
390PREHOOK: type: QUERY
391PREHOOK: Input: default@myinput1
392PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-31_327_4809407974402234126/-mr-10000
393POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.value
394POSTHOOK: type: QUERY
395POSTHOOK: Input: default@myinput1
396POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-31_327_4809407974402234126/-mr-10000
397NULL	NULL	NULL	35
398NULL	NULL	48	NULL
399100	100	100	100
400PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.key
401PREHOOK: type: QUERY
402PREHOOK: Input: default@myinput1
403PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-35_742_1654943644282955382/-mr-10000
404POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.key = b.key
405POSTHOOK: type: QUERY
406POSTHOOK: Input: default@myinput1
407POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-35_742_1654943644282955382/-mr-10000
408NULL	NULL	NULL	35
40948	NULL	48	NULL
410100	100	100	100
411PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.value = b.value
412PREHOOK: type: QUERY
413PREHOOK: Input: default@myinput1
414PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-40_216_7170971377841192858/-mr-10000
415POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a RIGHT OUTER JOIN myinput1 b ON a.value = b.value
416POSTHOOK: type: QUERY
417POSTHOOK: Input: default@myinput1
418POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-40_216_7170971377841192858/-mr-10000
419NULL	35	NULL	35
420NULL	NULL	48	NULL
421100	100	100	100
422PREHOOK: query: CREATE TABLE smb_input1(key int, value int) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
423PREHOOK: type: CREATETABLE
424POSTHOOK: query: CREATE TABLE smb_input1(key int, value int) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
425POSTHOOK: type: CREATETABLE
426POSTHOOK: Output: default@smb_input1
427PREHOOK: query: CREATE TABLE smb_input2(key int, value int) CLUSTERED BY (value) SORTED BY (value) INTO 2 BUCKETS
428PREHOOK: type: CREATETABLE
429POSTHOOK: query: CREATE TABLE smb_input2(key int, value int) CLUSTERED BY (value) SORTED BY (value) INTO 2 BUCKETS
430POSTHOOK: type: CREATETABLE
431POSTHOOK: Output: default@smb_input2
432PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in1.txt' into table smb_input1
433PREHOOK: type: LOAD
434PREHOOK: Output: default@smb_input1
435POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in1.txt' into table smb_input1
436POSTHOOK: type: LOAD
437POSTHOOK: Output: default@smb_input1
438PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in2.txt' into table smb_input1
439PREHOOK: type: LOAD
440PREHOOK: Output: default@smb_input1
441POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in2.txt' into table smb_input1
442POSTHOOK: type: LOAD
443POSTHOOK: Output: default@smb_input1
444PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in1.txt' into table smb_input2
445PREHOOK: type: LOAD
446PREHOOK: Output: default@smb_input2
447POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in1.txt' into table smb_input2
448POSTHOOK: type: LOAD
449POSTHOOK: Output: default@smb_input2
450PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in2.txt' into table smb_input2
451PREHOOK: type: LOAD
452PREHOOK: Output: default@smb_input2
453POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in2.txt' into table smb_input2
454POSTHOOK: type: LOAD
455POSTHOOK: Output: default@smb_input2
456PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key = b.key ORDER BY a.key
457PREHOOK: type: QUERY
458PREHOOK: Input: default@smb_input1
459PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-45_071_1721369920851863145/-mr-10000
460POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key = b.key ORDER BY a.key
461POSTHOOK: type: QUERY
462POSTHOOK: Input: default@smb_input1
463POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-45_071_1721369920851863145/-mr-10000
46448	NULL	48	NULL
465100	100	100	100
466148	NULL	148	NULL
467200	200	200	200
468PREHOOK: 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
469PREHOOK: type: QUERY
470PREHOOK: Input: default@smb_input1
471PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-52_288_5442108787449062892/-mr-10000
472POSTHOOK: 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
473POSTHOOK: type: QUERY
474POSTHOOK: Input: default@smb_input1
475POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-52_288_5442108787449062892/-mr-10000
476100	100	100	100
477200	200	200	200
478PREHOOK: 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
479PREHOOK: type: QUERY
480PREHOOK: Input: default@smb_input1
481PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-59_488_9220251315068456695/-mr-10000
482POSTHOOK: 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
483POSTHOOK: type: QUERY
484POSTHOOK: Input: default@smb_input1
485POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-55-59_488_9220251315068456695/-mr-10000
486NULL	NULL	NULL	35
487NULL	NULL	NULL	135
48848	NULL	48	NULL
489100	100	100	100
490148	NULL	148	NULL
491200	200	200	200
492PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key = b.key ORDER BY a.key
493PREHOOK: type: QUERY
494PREHOOK: Input: default@smb_input1
495PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-06_798_1515908496616104358/-mr-10000
496POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a JOIN smb_input1 b ON a.key = b.key ORDER BY a.key
497POSTHOOK: type: QUERY
498POSTHOOK: Input: default@smb_input1
499POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-06_798_1515908496616104358/-mr-10000
50048	NULL	48	NULL
501100	100	100	100
502148	NULL	148	NULL
503200	200	200	200
504PREHOOK: 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
505PREHOOK: type: QUERY
506PREHOOK: Input: default@smb_input1
507PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-13_978_37675414267460205/-mr-10000
508POSTHOOK: 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
509POSTHOOK: type: QUERY
510POSTHOOK: Input: default@smb_input1
511POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-13_978_37675414267460205/-mr-10000
512NULL	35	NULL	NULL
513NULL	135	NULL	NULL
51448	NULL	48	NULL
515100	100	100	100
516148	NULL	148	NULL
517200	200	200	200
518PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN smb_input2 b ON a.key = b.value ORDER BY a.key
519PREHOOK: type: QUERY
520PREHOOK: Input: default@smb_input1
521PREHOOK: Input: default@smb_input2
522PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-21_231_8292843591044391733/-mr-10000
523POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN smb_input2 b ON a.key = b.value ORDER BY a.key
524POSTHOOK: type: QUERY
525POSTHOOK: Input: default@smb_input1
526POSTHOOK: Input: default@smb_input2
527POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-21_231_8292843591044391733/-mr-10000
528100	100	100	100
529200	200	200	200
530PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a JOIN smb_input2 b ON a.key = b.value ORDER BY a.key
531PREHOOK: type: QUERY
532PREHOOK: Input: default@smb_input1
533PREHOOK: Input: default@smb_input2
534PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-28_835_6286309168082618901/-mr-10000
535POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1 a JOIN smb_input2 b ON a.key = b.value ORDER BY a.key
536POSTHOOK: type: QUERY
537POSTHOOK: Input: default@smb_input1
538POSTHOOK: Input: default@smb_input2
539POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-28_835_6286309168082618901/-mr-10000
540100	100	100	100
541200	200	200	200
542PREHOOK: 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
543PREHOOK: type: QUERY
544PREHOOK: Input: default@smb_input1
545PREHOOK: Input: default@smb_input2
546PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-36_026_7352279404756888950/-mr-10000
547POSTHOOK: 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
548POSTHOOK: type: QUERY
549POSTHOOK: Input: default@smb_input1
550POSTHOOK: Input: default@smb_input2
551POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-36_026_7352279404756888950/-mr-10000
552NULL	35	NULL	NULL
553NULL	135	NULL	NULL
55448	NULL	NULL	NULL
555100	100	100	100
556148	NULL	NULL	NULL
557200	200	200	200
558PREHOOK: 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
559PREHOOK: type: QUERY
560PREHOOK: Input: default@smb_input1
561PREHOOK: Input: default@smb_input2
562PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-43_251_628261964080538715/-mr-10000
563POSTHOOK: 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
564POSTHOOK: type: QUERY
565POSTHOOK: Input: default@smb_input1
566POSTHOOK: Input: default@smb_input2
567POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-43_251_628261964080538715/-mr-10000
568NULL	NULL	NULL	35
569NULL	NULL	NULL	135
570NULL	NULL	48	NULL
571100	100	100	100
572NULL	NULL	148	NULL
573200	200	200	200
574PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input2 a JOIN smb_input2 b ON a.value = b.value ORDER BY a.value
575PREHOOK: type: QUERY
576PREHOOK: Input: default@smb_input2
577PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-50_368_3840876669646785753/-mr-10000
578POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input2 a JOIN smb_input2 b ON a.value = b.value ORDER BY a.value
579POSTHOOK: type: QUERY
580POSTHOOK: Input: default@smb_input2
581POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-50_368_3840876669646785753/-mr-10000
582NULL	35	NULL	35
583100	100	100	100
584NULL	135	NULL	135
585200	200	200	200
586PREHOOK: 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
587PREHOOK: type: QUERY
588PREHOOK: Input: default@smb_input2
589PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-57_464_1575904257589847287/-mr-10000
590POSTHOOK: 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
591POSTHOOK: type: QUERY
592POSTHOOK: Input: default@smb_input2
593POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-56-57_464_1575904257589847287/-mr-10000
594NULL	35	NULL	35
595NULL	135	NULL	135
596NULL	NULL	48	NULL
597100	100	100	100
598NULL	NULL	148	NULL
599200	200	200	200
600PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input2 a JOIN smb_input2 b ON a.value = b.value ORDER BY a.value
601PREHOOK: type: QUERY
602PREHOOK: Input: default@smb_input2
603PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-57-04_710_6771480365280106011/-mr-10000
604POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input2 a JOIN smb_input2 b ON a.value = b.value ORDER BY a.value
605POSTHOOK: type: QUERY
606POSTHOOK: Input: default@smb_input2
607POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-57-04_710_6771480365280106011/-mr-10000
608NULL	35	NULL	35
609100	100	100	100
610NULL	135	NULL	135
611200	200	200	200
612PREHOOK: 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
613PREHOOK: type: QUERY
614PREHOOK: Input: default@smb_input2
615PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-57-11_842_9028034862567967736/-mr-10000
616POSTHOOK: 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
617POSTHOOK: type: QUERY
618POSTHOOK: Input: default@smb_input2
619POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_03-57-11_842_9028034862567967736/-mr-10000
620NULL	35	NULL	35
621NULL	135	NULL	135
62248	NULL	NULL	NULL
623100	100	100	100
624148	NULL	NULL	NULL
625200	200	200	200