Saving all output to "!!{outputDirectory}!!/uniquejoin.q.raw". Enter "record" with no arguments to stop it.
>>>  !run !!{qFileDirectory}!!/uniquejoin.q
>>>  CREATE TABLE T1(key STRING, val STRING) STORED AS TEXTFILE;
No rows affected 
>>>  CREATE TABLE T2(key STRING, val STRING) STORED AS TEXTFILE;
No rows affected 
>>>  CREATE TABLE T3(key STRING, val STRING) STORED AS TEXTFILE;
No rows affected 
>>>  
>>>  LOAD DATA LOCAL INPATH '../data/files/T1.txt' INTO TABLE T1;
No rows affected 
>>>  LOAD DATA LOCAL INPATH '../data/files/T2.txt' INTO TABLE T2;
No rows affected 
>>>  LOAD DATA LOCAL INPATH '../data/files/T3.txt' INTO TABLE T3;
No rows affected 
>>>  
>>>  FROM UNIQUEJOIN PRESERVE T1 a (a.key), PRESERVE T2 b (b.key), PRESERVE T3 c (c.key) 
SELECT a.key, b.key, c.key;
'key','key','key'
'1','',''
'2','2','2'
'3','3',''
'','4','4'
'','5',''
'','','6'
'7','','7'
'8','8',''
'8','8',''
'8','8',''
'8','8',''
11 rows selected 
>>>  
>>>  FROM UNIQUEJOIN T1 a (a.key), T2 b (b.key), T3 c (c.key) 
SELECT a.key, b.key, c.key;
'key','key','key'
'2','2','2'
1 row selected 
>>>  
>>>  FROM UNIQUEJOIN T1 a (a.key), T2 b (b.key-1), T3 c (c.key) 
SELECT a.key, b.key, c.key;
'key','key','key'
'2','3','2'
'7','8','7'
'7','8','7'
3 rows selected 
>>>  
>>>  FROM UNIQUEJOIN PRESERVE T1 a (a.key, a.val), PRESERVE T2 b (b.key, b.val), PRESERVE T3 c (c.key, c.val) 
SELECT a.key, a.val, b.key, b.val, c.key, c.val;
'key','val','key','val','key','val'
'1','11','','','',''
'2','12','','','2','12'
'','','2','22','',''
'3','13','3','13','',''
'','','4','14','4','14'
'','','5','15','',''
'','','','','6','16'
'7','17','','','7','17'
'8','18','8','18','',''
'8','18','8','18','',''
'8','28','','','',''
11 rows selected 
>>>  
>>>  FROM UNIQUEJOIN PRESERVE T1 a (a.key), T2 b (b.key), PRESERVE T3 c (c.key) 
SELECT a.key, b.key, c.key;
'key','key','key'
'1','',''
'2','2','2'
'3','3',''
'','4','4'
'','','6'
'7','','7'
'8','8',''
'8','8',''
'8','8',''
'8','8',''
10 rows selected 
>>>  
>>>  FROM UNIQUEJOIN PRESERVE T1 a (a.key), T2 b(b.key) 
SELECT a.key, b.key;
'key','key'
'1',''
'2','2'
'3','3'
'7',''
'8','8'
'8','8'
'8','8'
'8','8'
8 rows selected 
>>>  !record