hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 王鹏飞 <wpf5...@gmail.com>
Subject Re: Hive create table line terminated by '\n'
Date Tue, 13 Jan 2015 06:54:54 GMT
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 <xiaoyzhu@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:wpf5511@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.
>

Mime
View raw message