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

2015-01-12 Thread 王鹏飞
Thank you,maybe i didn't express my question explicitly.I know the hive create table clause,and there exists FIELDS TERMINATED BY etc. For example,if i use FIELDS TERMINATED BY ' ,',what if the ' ,' is contained in One field,hive will use the rule to separate One field. You might suggested me to c

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

2015-01-12 Thread 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...@gma

Hive create table line terminated by '\n'

2015-01-12 Thread 王鹏飞
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.