Search code examples
hadoophivedelimitercreate-table

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


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;