The default delimiter '\001' if you havn't set when create a hivetable. . you can change it to others delimiter. for example. hive CREATE TABLE IF NOT EXISTS student1 (sno INT, sname STRING, age INT, sex STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE;