CODEWITHSUNDEEP
hadoophivedelimitercreate-table
PriyankaB
PriyankaB

Reputation: 85

What is the default delimiter for Hive tables?

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);

Upvotes: 3

Views: 13807

Answers (1)

HbnKing
HbnKing

Reputation: 1882

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;

Upvotes: 7

Related Questions