hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ajo Fod <ajo....@gmail.com>
Subject Re: Importing a file wich includes delimiter like into HIVE
Date Thu, 17 Feb 2011 13:52:54 GMT
ah ... try :
https://issues.apache.org/jira/browse/HIVE-136

it says that  one can escape using:

CREATE TABLE table1 (a STRING, b STRING)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' ESCAPED BY '\\';

Cheers,
Ajo


2011/2/17 안의건 <ahneuigun@gmail.com>

> Dear All
>
> Thank you for who gave me advices, but it seems that I didn't explained my
> problem exactly.
> I have asked a question regarding 'Imporing a file wich include delimiter
> into HIVE'.
>
> In this case, I need to import a file wich includes " | " pipe without
> terminating the importing process.
>
> As you all know, other language programs have escaping method like "/", "
> `  ` ".
>
> What should I do for escaping when I import file inot HIVE?
>
> Regards,
> Henny Ahn (ahneuigun@gamil.com)
>
>
>
>
>
>
> 2011/2/15 hadoop n00b <new2hive@gmail.com>
>
>  Or try the ascii value like "*DELIMITED FIELDS TERMINATED BY '124'*"
>>
>> See if that helps.
>>
>> Cheers!
>>
>>   On Mon, Feb 14, 2011 at 9:44 PM, Ajo Fod <ajo.fod@gmail.com> wrote:
>>
>>> use delimited by "|"   ... are you using this syntax:
>>>
>>> Are you saying that the syntax here not work for you?
>>>
>>> http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL#Create_Table
>>>
>>> ... if you tried this ... ccould it be that the error may be caused by something
else.
>>>
>>> Cheers,
>>> -Ajo
>>>
>>>
>>>
>>> On Mon, Feb 14, 2011 at 3:40 AM, 안의건 <ahneuigun@gmail.com> wrote:
>>>
>>>> Dear All
>>>>
>>>>
>>>> I need your opinions about the problem I encountered during the data
>>>> migration process.
>>>>
>>>> The file, which includes "|" pipe, is recognized as a Delimiter, and
>>>> than an error occurs.
>>>>
>>>> What could I do if I need to import a file wich includes delimiter like
>>>> into HIVE?
>>>>
>>>>
>>>> Regards,
>>>> Henny Ahn (ahneuigun@gamil.com)
>>>>
>>>
>>>
>>
>

Mime
View raw message