[Hive-user] Importing a file wich includes delimiter like into HIVE

On Mon, Feb 14, 2011 at 3:40 AM, 안의건 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 ([email protected])

On Mon, Feb 14, 2011 at 9:44 PM, Ajo Fod 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

Or try the ascii value like "*DELIMITED FIELDS TERMINATED BY '124'*"

See if that helps.

Cheers!

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 ([email protected])






2011/2/15 hadoop n00b <[email protected]>

Or try the ascii value like "*DELIMITED FIELDS TERMINATED BY '124'*"