-- SORT_QUERY_RESULTS | |
CREATE TABLE joinone(key1 int, key2 int, value int); | |
LOAD DATA LOCAL INPATH '../../data/files/in5.txt' INTO TABLE joinone; | |
CREATE TABLE joinTwo(key1 int, key2 int, value int); | |
LOAD DATA LOCAL INPATH '../../data/files/in6.txt' INTO TABLE joinTwo; | |
SELECT * FROM joinone JOIN joinTwo ON(joinone.key2=joinTwo.key2); |