PREHOOK: query: CREATE TABLE join_1to1_1(key1 int, key2 int, value int)
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE join_1to1_1(key1 int, key2 int, value int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@join_1to1_1
PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in5.txt' INTO TABLE join_1to1_1
PREHOOK: type: LOAD
PREHOOK: Output: default@join_1to1_1
POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in5.txt' INTO TABLE join_1to1_1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@join_1to1_1
PREHOOK: query: CREATE TABLE join_1to1_2(key1 int, key2 int, value int)
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE join_1to1_2(key1 int, key2 int, value int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@join_1to1_2
PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in6.txt' INTO TABLE join_1to1_2
PREHOOK: type: LOAD
PREHOOK: Output: default@join_1to1_2
POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in6.txt' INTO TABLE join_1to1_2
POSTHOOK: type: LOAD
POSTHOOK: Output: default@join_1to1_2
PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-20-29_153_819287332537414913/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-20-29_153_819287332537414913/-mr-10000
5	10005	66	5	10005	66
20	10020	66	20	10020	66
25	10025	88	25	10025	66
30	10030	66	30	10030	88
35	10035	88	35	10035	88
40	10040	66	40	10040	66
40	10040	66	40	10040	88
40	10040	88	40	10040	66
40	10040	88	40	10040	88
50	10050	66	50	10050	88
50	10050	66	50	10050	66
50	10050	66	50	10050	66
50	10050	88	50	10050	88
50	10050	88	50	10050	66
50	10050	88	50	10050	66
50	10050	88	50	10050	88
50	10050	88	50	10050	66
50	10050	88	50	10050	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-20-37_205_3853401411582824516/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-20-37_205_3853401411582824516/-mr-10000
NULL	NULL	66	NULL	NULL	NULL
NULL	10050	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL	66
NULL	NULL	NULL	NULL	10050	66
5	10005	66	5	10005	66
NULL	NULL	NULL	10	10010	66
15	10015	66	NULL	NULL	NULL
20	10020	66	20	10020	66
25	10025	88	25	10025	66
30	10030	66	30	10030	88
35	10035	88	35	10035	88
40	10040	66	40	10040	66
40	10040	66	40	10040	88
40	10040	88	40	10040	66
40	10040	88	40	10040	88
50	10050	66	50	10050	88
50	10050	66	50	10050	66
50	10050	66	50	10050	66
50	10050	88	50	10050	88
50	10050	88	50	10050	66
50	10050	88	50	10050	66
50	10050	88	50	10050	88
50	10050	88	50	10050	66
50	10050	88	50	10050	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-20-45_133_5000785547018037129/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-20-45_133_5000785547018037129/-mr-10000
NULL	10050	66	NULL	NULL	NULL
NULL	NULL	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL	66
NULL	NULL	NULL	NULL	10050	66
5	10005	66	5	10005	66
NULL	NULL	NULL	10	10010	66
15	10015	66	NULL	NULL	NULL
20	10020	66	20	10020	66
NULL	NULL	NULL	25	10025	66
30	10030	66	NULL	NULL	NULL
40	10040	66	40	10040	66
50	10050	66	50	10050	66
50	10050	66	50	10050	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	NULL	NULL	NULL
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	80	10040	66
NULL	NULL	NULL	80	10040	66
PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-20-57_477_8268626202456442766/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-20-57_477_8268626202456442766/-mr-10000
NULL	NULL	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL	66
NULL	10050	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	10050	66
5	10005	66	5	10005	66
NULL	NULL	NULL	10	10010	66
15	10015	66	NULL	NULL	NULL
20	10020	66	20	10020	66
25	10025	88	25	10025	66
30	10030	66	30	10030	88
35	10035	88	35	10035	88
40	10040	66	40	10040	66
40	10040	66	40	10040	88
40	10040	88	40	10040	66
40	10040	88	40	10040	88
50	10050	66	50	10050	88
50	10050	66	50	10050	66
50	10050	66	50	10050	66
50	10050	88	50	10050	88
50	10050	88	50	10050	66
50	10050	88	50	10050	66
50	10050	88	50	10050	88
50	10050	88	50	10050	66
50	10050	88	50	10050	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-21-07_530_5883037614503394382/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-21-07_530_5883037614503394382/-mr-10000
NULL	NULL	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL	66
NULL	10050	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	10050	66
5	10005	66	5	10005	66
NULL	NULL	NULL	10	10010	66
15	10015	66	NULL	NULL	NULL
20	10020	66	20	10020	66
NULL	NULL	NULL	25	10025	66
30	10030	66	NULL	NULL	NULL
40	10040	66	40	10040	66
50	10050	66	50	10050	66
50	10050	66	50	10050	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	NULL	NULL	NULL
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	80	10040	66
NULL	NULL	NULL	80	10040	66
PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-21-18_282_7317084573894626898/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-21-18_282_7317084573894626898/-mr-10000
5	10005	66	5	10005	66
20	10020	66	20	10020	66
25	10025	88	25	10025	66
30	10030	66	30	10030	88
35	10035	88	35	10035	88
40	10040	66	40	10040	66
40	10040	66	40	10040	88
40	10040	88	40	10040	66
40	10040	88	40	10040	88
50	10050	66	50	10050	88
50	10050	66	50	10050	66
50	10050	88	50	10050	88
50	10050	88	50	10050	66
50	10050	88	50	10050	88
50	10050	88	50	10050	66
50	10050	66	50	10050	66
50	10050	88	50	10050	66
50	10050	88	50	10050	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-21-28_780_2696570463196136436/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-21-28_780_2696570463196136436/-mr-10000
NULL	NULL	66	NULL	NULL	NULL
NULL	10050	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL	66
NULL	NULL	NULL	NULL	10050	66
5	10005	66	5	10005	66
NULL	NULL	NULL	10	10010	66
15	10015	66	NULL	NULL	NULL
20	10020	66	20	10020	66
25	10025	88	25	10025	66
30	10030	66	30	10030	88
35	10035	88	35	10035	88
40	10040	66	40	10040	66
40	10040	66	40	10040	88
40	10040	88	40	10040	66
40	10040	88	40	10040	88
50	10050	66	50	10050	88
50	10050	66	50	10050	66
50	10050	88	50	10050	88
50	10050	88	50	10050	66
50	10050	88	50	10050	88
50	10050	88	50	10050	66
50	10050	66	50	10050	66
50	10050	88	50	10050	66
50	10050	88	50	10050	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-21-42_434_1480667017077026029/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-21-42_434_1480667017077026029/-mr-10000
NULL	10050	66	NULL	NULL	NULL
NULL	NULL	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL	66
NULL	NULL	NULL	NULL	10050	66
5	10005	66	5	10005	66
NULL	NULL	NULL	10	10010	66
15	10015	66	NULL	NULL	NULL
20	10020	66	20	10020	66
NULL	NULL	NULL	25	10025	66
30	10030	66	NULL	NULL	NULL
40	10040	66	40	10040	66
50	10050	66	50	10050	66
50	10050	66	50	10050	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	NULL	NULL	NULL
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	80	10040	66
NULL	NULL	NULL	80	10040	66
PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-21-51_288_5512301142456705063/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-21-51_288_5512301142456705063/-mr-10000
NULL	NULL	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL	66
NULL	10050	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	10050	66
5	10005	66	5	10005	66
NULL	NULL	NULL	10	10010	66
15	10015	66	NULL	NULL	NULL
20	10020	66	20	10020	66
25	10025	88	25	10025	66
30	10030	66	30	10030	88
35	10035	88	35	10035	88
40	10040	66	40	10040	66
40	10040	66	40	10040	88
40	10040	88	40	10040	66
40	10040	88	40	10040	88
50	10050	66	50	10050	88
50	10050	66	50	10050	66
50	10050	88	50	10050	88
50	10050	88	50	10050	66
50	10050	88	50	10050	88
50	10050	88	50	10050	66
50	10050	66	50	10050	66
50	10050	88	50	10050	66
50	10050	88	50	10050	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-22-02_120_8975661308229780900/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-22-02_120_8975661308229780900/-mr-10000
NULL	NULL	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL	66
NULL	10050	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	10050	66
5	10005	66	5	10005	66
NULL	NULL	NULL	10	10010	66
15	10015	66	NULL	NULL	NULL
20	10020	66	20	10020	66
NULL	NULL	NULL	25	10025	66
30	10030	66	NULL	NULL	NULL
40	10040	66	40	10040	66
50	10050	66	50	10050	66
50	10050	66	50	10050	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	NULL	NULL	NULL
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	80	10040	66
NULL	NULL	NULL	80	10040	66
PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-22-12_482_4462251488601235627/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-22-12_482_4462251488601235627/-mr-10000
5	10005	66	5	10005	66
20	10020	66	20	10020	66
25	10025	88	25	10025	66
30	10030	66	30	10030	88
35	10035	88	35	10035	88
40	10040	66	40	10040	66
40	10040	88	40	10040	66
40	10040	66	40	10040	88
40	10040	88	40	10040	88
50	10050	66	50	10050	88
50	10050	88	50	10050	88
50	10050	88	50	10050	88
50	10050	66	50	10050	66
50	10050	88	50	10050	66
50	10050	88	50	10050	66
50	10050	66	50	10050	66
50	10050	88	50	10050	66
50	10050	88	50	10050	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-22-23_225_2252852873807958052/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-22-23_225_2252852873807958052/-mr-10000
NULL	NULL	66	NULL	NULL	NULL
NULL	10050	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL	66
NULL	NULL	NULL	NULL	10050	66
5	10005	66	5	10005	66
NULL	NULL	NULL	10	10010	66
15	10015	66	NULL	NULL	NULL
20	10020	66	20	10020	66
25	10025	88	25	10025	66
30	10030	66	30	10030	88
35	10035	88	35	10035	88
40	10040	66	40	10040	66
40	10040	88	40	10040	66
40	10040	66	40	10040	88
40	10040	88	40	10040	88
50	10050	66	50	10050	88
50	10050	88	50	10050	88
50	10050	88	50	10050	88
50	10050	66	50	10050	66
50	10050	88	50	10050	66
50	10050	88	50	10050	66
50	10050	66	50	10050	66
50	10050	88	50	10050	66
50	10050	88	50	10050	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-22-36_933_7497927262929255928/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-22-36_933_7497927262929255928/-mr-10000
NULL	10050	66	NULL	NULL	NULL
NULL	NULL	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL	66
NULL	NULL	NULL	NULL	10050	66
5	10005	66	5	10005	66
NULL	NULL	NULL	10	10010	66
15	10015	66	NULL	NULL	NULL
20	10020	66	20	10020	66
NULL	NULL	NULL	25	10025	66
30	10030	66	NULL	NULL	NULL
40	10040	66	40	10040	66
50	10050	66	50	10050	66
50	10050	66	50	10050	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	NULL	NULL	NULL
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	80	10040	66
NULL	NULL	NULL	80	10040	66
PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-22-46_887_6402928547373416872/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-22-46_887_6402928547373416872/-mr-10000
NULL	NULL	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL	66
NULL	10050	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	10050	66
5	10005	66	5	10005	66
NULL	NULL	NULL	10	10010	66
15	10015	66	NULL	NULL	NULL
20	10020	66	20	10020	66
25	10025	88	25	10025	66
30	10030	66	30	10030	88
35	10035	88	35	10035	88
40	10040	66	40	10040	66
40	10040	88	40	10040	66
40	10040	66	40	10040	88
40	10040	88	40	10040	88
50	10050	66	50	10050	88
50	10050	88	50	10050	88
50	10050	88	50	10050	88
50	10050	66	50	10050	66
50	10050	88	50	10050	66
50	10050	88	50	10050	66
50	10050	66	50	10050	66
50	10050	88	50	10050	66
50	10050	88	50	10050	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-22-57_346_2072799218057878640/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-22-57_346_2072799218057878640/-mr-10000
NULL	NULL	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL	66
NULL	10050	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	10050	66
5	10005	66	5	10005	66
NULL	NULL	NULL	10	10010	66
15	10015	66	NULL	NULL	NULL
20	10020	66	20	10020	66
NULL	NULL	NULL	25	10025	66
30	10030	66	NULL	NULL	NULL
40	10040	66	40	10040	66
50	10050	66	50	10050	66
50	10050	66	50	10050	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	NULL	NULL	NULL
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	80	10040	66
NULL	NULL	NULL	80	10040	66
PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-23-08_081_7330385664639520823/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-23-08_081_7330385664639520823/-mr-10000
5	10005	66	5	10005	66
20	10020	66	20	10020	66
25	10025	88	25	10025	66
30	10030	66	30	10030	88
35	10035	88	35	10035	88
40	10040	66	40	10040	66
40	10040	66	40	10040	88
40	10040	88	40	10040	66
40	10040	88	40	10040	88
50	10050	66	50	10050	88
50	10050	66	50	10050	66
50	10050	66	50	10050	66
50	10050	88	50	10050	88
50	10050	88	50	10050	66
50	10050	88	50	10050	66
50	10050	88	50	10050	88
50	10050	88	50	10050	66
50	10050	88	50	10050	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-23-20_605_1212073981863777868/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-23-20_605_1212073981863777868/-mr-10000
NULL	NULL	66	NULL	NULL	NULL
NULL	10050	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL	66
NULL	NULL	NULL	NULL	10050	66
5	10005	66	5	10005	66
NULL	NULL	NULL	10	10010	66
15	10015	66	NULL	NULL	NULL
20	10020	66	20	10020	66
25	10025	88	25	10025	66
30	10030	66	30	10030	88
35	10035	88	35	10035	88
40	10040	66	40	10040	66
40	10040	66	40	10040	88
40	10040	88	40	10040	66
40	10040	88	40	10040	88
50	10050	66	50	10050	88
50	10050	66	50	10050	66
50	10050	66	50	10050	66
50	10050	88	50	10050	88
50	10050	88	50	10050	66
50	10050	88	50	10050	66
50	10050	88	50	10050	88
50	10050	88	50	10050	66
50	10050	88	50	10050	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-23-32_030_1376413216376519019/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-23-32_030_1376413216376519019/-mr-10000
NULL	NULL	66	NULL	NULL	NULL
NULL	10050	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL	66
NULL	NULL	NULL	NULL	10050	66
5	10005	66	5	10005	66
NULL	NULL	NULL	10	10010	66
15	10015	66	NULL	NULL	NULL
20	10020	66	20	10020	66
25	10025	88	NULL	NULL	NULL
30	10030	66	NULL	NULL	NULL
NULL	NULL	NULL	30	10030	88
35	10035	88	NULL	NULL	NULL
NULL	NULL	NULL	35	10035	88
40	10040	66	40	10040	66
40	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	40	10040	88
40	10040	88	NULL	NULL	NULL
40	10040	88	NULL	NULL	NULL
NULL	NULL	NULL	40	10040	88
50	10050	66	NULL	NULL	NULL
NULL	NULL	NULL	50	10050	88
50	10050	66	50	10050	66
50	10050	66	50	10050	66
50	10050	88	NULL	NULL	NULL
NULL	NULL	NULL	50	10050	88
50	10050	88	NULL	NULL	NULL
50	10050	88	NULL	NULL	NULL
50	10050	88	NULL	NULL	NULL
NULL	NULL	NULL	50	10050	88
50	10050	88	NULL	NULL	NULL
50	10050	88	NULL	NULL	NULL
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	70	10040	88
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	70	10040	88
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	70	10040	88
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	70	10040	88
80	10040	88	NULL	NULL	NULL
80	10040	88	NULL	NULL	NULL
80	10040	88	NULL	NULL	NULL
80	10040	88	NULL	NULL	NULL
PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-23-41_827_8885174767015375192/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-23-41_827_8885174767015375192/-mr-10000
NULL	NULL	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL	66
NULL	10050	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	10050	66
5	10005	66	5	10005	66
NULL	NULL	NULL	10	10010	66
15	10015	66	NULL	NULL	NULL
20	10020	66	20	10020	66
25	10025	88	25	10025	66
30	10030	66	30	10030	88
35	10035	88	35	10035	88
40	10040	66	40	10040	66
40	10040	66	40	10040	88
40	10040	88	40	10040	66
40	10040	88	40	10040	88
50	10050	66	50	10050	88
50	10050	66	50	10050	66
50	10050	66	50	10050	66
50	10050	88	50	10050	88
50	10050	88	50	10050	66
50	10050	88	50	10050	66
50	10050	88	50	10050	88
50	10050	88	50	10050	66
50	10050	88	50	10050	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-23-51_892_5107339076100535083/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-23-51_892_5107339076100535083/-mr-10000
NULL	NULL	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL	66
NULL	10050	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	10050	66
5	10005	66	5	10005	66
NULL	NULL	NULL	10	10010	66
15	10015	66	NULL	NULL	NULL
20	10020	66	20	10020	66
25	10025	88	NULL	NULL	NULL
30	10030	66	NULL	NULL	NULL
NULL	NULL	NULL	30	10030	88
35	10035	88	NULL	NULL	NULL
NULL	NULL	NULL	35	10035	88
40	10040	66	40	10040	66
40	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	40	10040	88
40	10040	88	NULL	NULL	NULL
40	10040	88	NULL	NULL	NULL
NULL	NULL	NULL	40	10040	88
50	10050	66	NULL	NULL	NULL
NULL	NULL	NULL	50	10050	88
50	10050	66	50	10050	66
50	10050	66	50	10050	66
50	10050	88	NULL	NULL	NULL
NULL	NULL	NULL	50	10050	88
50	10050	88	NULL	NULL	NULL
50	10050	88	NULL	NULL	NULL
50	10050	88	NULL	NULL	NULL
NULL	NULL	NULL	50	10050	88
50	10050	88	NULL	NULL	NULL
50	10050	88	NULL	NULL	NULL
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	70	10040	88
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	70	10040	88
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	70	10040	88
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	70	10040	88
80	10040	88	NULL	NULL	NULL
80	10040	88	NULL	NULL	NULL
80	10040	88	NULL	NULL	NULL
80	10040	88	NULL	NULL	NULL
PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-24-05_457_7734550160785374741/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-24-05_457_7734550160785374741/-mr-10000
5	10005	66	5	10005	66
20	10020	66	20	10020	66
25	10025	88	25	10025	66
30	10030	66	30	10030	88
35	10035	88	35	10035	88
40	10040	66	40	10040	66
40	10040	66	40	10040	88
40	10040	88	40	10040	66
40	10040	88	40	10040	88
50	10050	66	50	10050	88
50	10050	66	50	10050	66
50	10050	88	50	10050	88
50	10050	88	50	10050	66
50	10050	88	50	10050	88
50	10050	88	50	10050	66
50	10050	66	50	10050	66
50	10050	88	50	10050	66
50	10050	88	50	10050	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-24-15_398_6526838758701035060/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-24-15_398_6526838758701035060/-mr-10000
NULL	NULL	66	NULL	NULL	NULL
NULL	10050	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL	66
NULL	NULL	NULL	NULL	10050	66
5	10005	66	5	10005	66
NULL	NULL	NULL	10	10010	66
15	10015	66	NULL	NULL	NULL
20	10020	66	20	10020	66
25	10025	88	25	10025	66
30	10030	66	30	10030	88
35	10035	88	35	10035	88
40	10040	66	40	10040	66
40	10040	66	40	10040	88
40	10040	88	40	10040	66
40	10040	88	40	10040	88
50	10050	66	50	10050	88
50	10050	66	50	10050	66
50	10050	88	50	10050	88
50	10050	88	50	10050	66
50	10050	88	50	10050	88
50	10050	88	50	10050	66
50	10050	66	50	10050	66
50	10050	88	50	10050	66
50	10050	88	50	10050	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-24-25_841_5052384962414662963/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-24-25_841_5052384962414662963/-mr-10000
NULL	NULL	66	NULL	NULL	NULL
NULL	10050	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL	66
NULL	NULL	NULL	NULL	10050	66
5	10005	66	5	10005	66
NULL	NULL	NULL	10	10010	66
15	10015	66	NULL	NULL	NULL
20	10020	66	20	10020	66
25	10025	88	NULL	NULL	NULL
30	10030	66	NULL	NULL	NULL
NULL	NULL	NULL	30	10030	88
35	10035	88	NULL	NULL	NULL
NULL	NULL	NULL	35	10035	88
40	10040	66	40	10040	66
40	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	40	10040	88
40	10040	88	NULL	NULL	NULL
40	10040	88	NULL	NULL	NULL
NULL	NULL	NULL	40	10040	88
50	10050	66	NULL	NULL	NULL
NULL	NULL	NULL	50	10050	88
50	10050	66	50	10050	66
50	10050	88	NULL	NULL	NULL
NULL	NULL	NULL	50	10050	88
50	10050	88	NULL	NULL	NULL
50	10050	88	NULL	NULL	NULL
NULL	NULL	NULL	50	10050	88
50	10050	88	NULL	NULL	NULL
50	10050	66	50	10050	66
50	10050	88	NULL	NULL	NULL
50	10050	88	NULL	NULL	NULL
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	70	10040	88
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	70	10040	88
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	70	10040	88
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	70	10040	88
80	10040	88	NULL	NULL	NULL
80	10040	88	NULL	NULL	NULL
80	10040	88	NULL	NULL	NULL
80	10040	88	NULL	NULL	NULL
PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-24-36_374_5468030835311850505/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-24-36_374_5468030835311850505/-mr-10000
NULL	NULL	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL	66
NULL	10050	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	10050	66
5	10005	66	5	10005	66
NULL	NULL	NULL	10	10010	66
15	10015	66	NULL	NULL	NULL
20	10020	66	20	10020	66
25	10025	88	25	10025	66
30	10030	66	30	10030	88
35	10035	88	35	10035	88
40	10040	66	40	10040	66
40	10040	66	40	10040	88
40	10040	88	40	10040	66
40	10040	88	40	10040	88
50	10050	66	50	10050	88
50	10050	66	50	10050	66
50	10050	88	50	10050	88
50	10050	88	50	10050	66
50	10050	88	50	10050	88
50	10050	88	50	10050	66
50	10050	66	50	10050	66
50	10050	88	50	10050	66
50	10050	88	50	10050	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-24-49_065_6955091567995311011/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-24-49_065_6955091567995311011/-mr-10000
NULL	NULL	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL	66
NULL	10050	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	10050	66
5	10005	66	5	10005	66
NULL	NULL	NULL	10	10010	66
15	10015	66	NULL	NULL	NULL
20	10020	66	20	10020	66
25	10025	88	NULL	NULL	NULL
30	10030	66	NULL	NULL	NULL
NULL	NULL	NULL	30	10030	88
35	10035	88	NULL	NULL	NULL
NULL	NULL	NULL	35	10035	88
40	10040	66	40	10040	66
40	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	40	10040	88
40	10040	88	NULL	NULL	NULL
40	10040	88	NULL	NULL	NULL
NULL	NULL	NULL	40	10040	88
50	10050	66	NULL	NULL	NULL
NULL	NULL	NULL	50	10050	88
50	10050	66	50	10050	66
50	10050	88	NULL	NULL	NULL
NULL	NULL	NULL	50	10050	88
50	10050	88	NULL	NULL	NULL
50	10050	88	NULL	NULL	NULL
NULL	NULL	NULL	50	10050	88
50	10050	88	NULL	NULL	NULL
50	10050	66	50	10050	66
50	10050	88	NULL	NULL	NULL
50	10050	88	NULL	NULL	NULL
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	70	10040	88
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	70	10040	88
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	70	10040	88
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	70	10040	88
80	10040	88	NULL	NULL	NULL
80	10040	88	NULL	NULL	NULL
80	10040	88	NULL	NULL	NULL
80	10040	88	NULL	NULL	NULL
PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-24-59_560_3592561556746118709/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-24-59_560_3592561556746118709/-mr-10000
5	10005	66	5	10005	66
20	10020	66	20	10020	66
25	10025	88	25	10025	66
30	10030	66	30	10030	88
35	10035	88	35	10035	88
40	10040	66	40	10040	66
40	10040	88	40	10040	66
40	10040	66	40	10040	88
40	10040	88	40	10040	88
50	10050	66	50	10050	88
50	10050	88	50	10050	88
50	10050	88	50	10050	88
50	10050	66	50	10050	66
50	10050	88	50	10050	66
50	10050	88	50	10050	66
50	10050	66	50	10050	66
50	10050	88	50	10050	66
50	10050	88	50	10050	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-25-10_152_5451154587710613858/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-25-10_152_5451154587710613858/-mr-10000
NULL	NULL	66	NULL	NULL	NULL
NULL	10050	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL	66
NULL	NULL	NULL	NULL	10050	66
5	10005	66	5	10005	66
NULL	NULL	NULL	10	10010	66
15	10015	66	NULL	NULL	NULL
20	10020	66	20	10020	66
25	10025	88	25	10025	66
30	10030	66	30	10030	88
35	10035	88	35	10035	88
40	10040	66	40	10040	66
40	10040	88	40	10040	66
40	10040	66	40	10040	88
40	10040	88	40	10040	88
50	10050	66	50	10050	88
50	10050	88	50	10050	88
50	10050	88	50	10050	88
50	10050	66	50	10050	66
50	10050	88	50	10050	66
50	10050	88	50	10050	66
50	10050	66	50	10050	66
50	10050	88	50	10050	66
50	10050	88	50	10050	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-25-19_903_3097300389666559778/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-25-19_903_3097300389666559778/-mr-10000
NULL	NULL	66	NULL	NULL	NULL
NULL	10050	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL	66
NULL	NULL	NULL	NULL	10050	66
5	10005	66	5	10005	66
NULL	NULL	NULL	10	10010	66
15	10015	66	NULL	NULL	NULL
20	10020	66	20	10020	66
25	10025	88	NULL	NULL	NULL
30	10030	66	NULL	NULL	NULL
NULL	NULL	NULL	30	10030	88
35	10035	88	NULL	NULL	NULL
NULL	NULL	NULL	35	10035	88
40	10040	66	40	10040	66
40	10040	88	NULL	NULL	NULL
40	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	40	10040	88
40	10040	88	NULL	NULL	NULL
NULL	NULL	NULL	40	10040	88
50	10050	66	NULL	NULL	NULL
NULL	NULL	NULL	50	10050	88
50	10050	88	NULL	NULL	NULL
NULL	NULL	NULL	50	10050	88
50	10050	88	NULL	NULL	NULL
NULL	NULL	NULL	50	10050	88
50	10050	66	50	10050	66
50	10050	88	NULL	NULL	NULL
50	10050	88	NULL	NULL	NULL
50	10050	66	50	10050	66
50	10050	88	NULL	NULL	NULL
50	10050	88	NULL	NULL	NULL
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	70	10040	88
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	70	10040	88
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	70	10040	88
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	70	10040	88
80	10040	88	NULL	NULL	NULL
80	10040	88	NULL	NULL	NULL
80	10040	88	NULL	NULL	NULL
80	10040	88	NULL	NULL	NULL
PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-25-32_785_5133007163551739713/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-25-32_785_5133007163551739713/-mr-10000
NULL	NULL	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL	66
NULL	10050	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	10050	66
5	10005	66	5	10005	66
NULL	NULL	NULL	10	10010	66
15	10015	66	NULL	NULL	NULL
20	10020	66	20	10020	66
25	10025	88	25	10025	66
30	10030	66	30	10030	88
35	10035	88	35	10035	88
40	10040	66	40	10040	66
40	10040	88	40	10040	66
40	10040	66	40	10040	88
40	10040	88	40	10040	88
50	10050	66	50	10050	88
50	10050	88	50	10050	88
50	10050	88	50	10050	88
50	10050	66	50	10050	66
50	10050	88	50	10050	66
50	10050	88	50	10050	66
50	10050	66	50	10050	66
50	10050	88	50	10050	66
50	10050	88	50	10050	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
70	10040	66	70	10040	88
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
80	10040	88	80	10040	66
PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-25-43_923_6388278859724005632/-mr-10000
POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-21_00-25-43_923_6388278859724005632/-mr-10000
NULL	NULL	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL	66
NULL	10050	66	NULL	NULL	NULL
NULL	NULL	NULL	NULL	10050	66
5	10005	66	5	10005	66
NULL	NULL	NULL	10	10010	66
15	10015	66	NULL	NULL	NULL
20	10020	66	20	10020	66
25	10025	88	NULL	NULL	NULL
30	10030	66	NULL	NULL	NULL
NULL	NULL	NULL	30	10030	88
35	10035	88	NULL	NULL	NULL
NULL	NULL	NULL	35	10035	88
40	10040	66	40	10040	66
40	10040	88	NULL	NULL	NULL
40	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	40	10040	88
40	10040	88	NULL	NULL	NULL
NULL	NULL	NULL	40	10040	88
50	10050	66	NULL	NULL	NULL
NULL	NULL	NULL	50	10050	88
50	10050	88	NULL	NULL	NULL
NULL	NULL	NULL	50	10050	88
50	10050	88	NULL	NULL	NULL
NULL	NULL	NULL	50	10050	88
50	10050	66	50	10050	66
50	10050	88	NULL	NULL	NULL
50	10050	88	NULL	NULL	NULL
50	10050	66	50	10050	66
50	10050	88	NULL	NULL	NULL
50	10050	88	NULL	NULL	NULL
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
60	10040	66	60	10040	66
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	70	10040	88
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	70	10040	88
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	70	10040	88
70	10040	66	NULL	NULL	NULL
NULL	NULL	NULL	70	10040	88
80	10040	88	NULL	NULL	NULL
80	10040	88	NULL	NULL	NULL
80	10040	88	NULL	NULL	NULL
80	10040	88	NULL	NULL	NULL