What is the default delimiter for Hive tables? What is the default delimiter for Hive tables? hadoop hadoop

What is the default delimiter for Hive tables?


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;