CREATE TABLE INPUT4(KEY STRING, VALUE STRING) STORED AS TEXTFILE;
LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE INPUT4;

EXPLAIN
SELECT a.KEY2
FROM (SELECT INPUT4.*, INPUT4.KEY as KEY2
      FROM INPUT4) a
ORDER BY KEY2 LIMIT 10;

SELECT a.KEY2
FROM (SELECT INPUT4.*, INPUT4.KEY as KEY2
      FROM INPUT4) a
ORDER BY KEY2 LIMIT 10;