Consider using dataformat other than TEXT such as sequence file. On Mon, Jan 12, 2015 at 10:54 PM, 王鹏飞 <wpf5...@gmail.com> wrote:
> 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. >> > >
