hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Xuefu Zhang <xzh...@cloudera.com>
Subject Re: Hive create table line terminated by '\n'
Date Tue, 13 Jan 2015 17:42:32 GMT
Consider using dataformat other than TEXT such as sequence file.

On Mon, Jan 12, 2015 at 10:54 PM, 王鹏飞 <wpf5511@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 <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