You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by 안의건 <ah...@gmail.com> on 2011/02/14 12:40:35 UTC
Importing a file wich includes delimiter like into HIVE
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)
Re: Importing a file wich includes delimiter like into HIVE
Posted by Ajo Fod <aj...@gmail.com>.
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 안의건 <ah...@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 <ne...@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 <aj...@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, 안의건 <ah...@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)
>>>>
>>>
>>>
>>
>
Re: Importing a file wich includes delimiter like into HIVE
Posted by 안의건 <ah...@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 <ne...@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 <aj...@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, 안의건 <ah...@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)
>>>
>>
>>
>
Re: Importing a file wich includes delimiter like into HIVE
Posted by hadoop n00b <ne...@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 <aj...@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, 안의건 <ah...@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)
>>
>
>
Re: Importing a file wich includes delimiter like into HIVE
Posted by Ajo Fod <aj...@gmail.com>.
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, 안의건 <ah...@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)
>