CREATE TABLE nullscript(KEY STRING, VALUE STRING) STORED AS TEXTFILE; | |
LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE nullscript; | |
LOAD DATA LOCAL INPATH '../../data/files/nullfile.txt' INTO TABLE nullscript; | |
explain | |
select transform(key) using 'cat' as key1 from nullscript; | |
select transform(key) using 'cat' as key1 from nullscript; | |