Can you give me a simple example like table only contains one string column,and in that sting column it contains '\n' as the content ?
On Wed, Jan 14, 2015 at 1:42 AM, Xuefu Zhang <xzh...@cloudera.com> wrote: > 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. >>> >> >> >
