
CREATE TABLE T1_n78(key STRING, value STRING) STORED AS TEXTFILE;
LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE T1_n78;
LOAD DATA LOCAL INPATH '../../data/files/kv2.txt' INTO TABLE T1_n78;


CREATE TABLE T2_n47(key STRING, value STRING);

EXPLAIN 
INSERT OVERWRITE TABLE T2_n47 SELECT * FROM (SELECT * FROM T1_n78 DISTRIBUTE BY key) T ORDER BY key, value LIMIT 20;

INSERT OVERWRITE TABLE T2_n47 SELECT * FROM (SELECT * FROM T1_n78 DISTRIBUTE BY key) T ORDER BY key, value LIMIT 20;

SELECT * FROM T2_n47 ORDER BY key, value;