Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

like image 300
PriyankaB Avatar asked Jan 17 '26 13:01

PriyankaB


1 Answers

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;
like image 86
HbnKing Avatar answered Jan 20 '26 04:01

HbnKing



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!