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 change the fields terminator,But how about the lines terminator?The Lines Terminator only support '\n',So the problem is what could i do if one column or field contains the '\n'?
On Tue, Jan 13, 2015 at 2:25 PM, Xiaoyong Zhu <xiaoy...@microsoft.com> wrote: > 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. >
