What is the default delimiter for Hive tables?

Question

If we don't mention any delimiter while creating a table, is there any default delimiter hive takes?

create table logs (ts bigint, line string) partitioned by (dt String, country String);

Solution

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;

Comments

[Daniel]

Welcome to Stack Overflow, please review: stackoverflow.com/help/how-to-ask

[HbnKing]

@TKHN had you use Google to find out?

[rosefun]

What is the meaning of STORED AS TEXTFILE? Any other file format in hive table?