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?

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.

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?

... if you tried this ... ccould it be that the error may be caused by something else.


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?

Henny Ahn (ahneuigun@gamil.com)

Search Discussions

Discussion Posts


Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 4 of 5 | next ›
Discussion Overview
groupuser @
categorieshive, hadoop
postedFeb 14, '11 at 11:41a
activeFeb 17, '11 at 1:53p

3 users in discussion

Ajo Fod: 2 posts 안의건: 2 posts Hadoop n00b: 1 post



site design / logo © 2022 Grokbase