CREATE TABLE test(a0 FLOAT,a1 FLOAT) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE; LOAD DATA LOCAL INPATH '/path/to/file/Test_Data.txt' OVERWRITE INTO TABLE test;