RE: Hive create table line terminated by '\n'

[Xiaoyong Zhu]

I guess you could use fields terminated by clause..
CREATE TABLE IF NOT EXISTS default.table_name
ROW FORMAT DELIMITED
        FIELDS TERMINATED BY '\001'
        COLLECTION ITEMS TERMINATED BY '\002'
        MAP KEYS TERMINATED BY '\003'
STORED AS TEXTFILE


Xiaoyong

From: 王鹏飞 [mailto:wpf5...@gmail.com]
Sent: Tuesday, January 13, 2015 2:15 PM
To: user@hive.apache.org
Subject: Hive create table line terminated by '\n'

At default hive table lines terminated by only supports '\n' right now;But if 
there is a column that contains a '\n',how could i do ? Hive split the column 
and went wrong,Is there any solutions ? Thank you.