FAQ
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)

Search Discussions

  • Ajo Fod at Feb 14, 2011 at 4:15 pm
    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, 안의건 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)
  • Hadoop n00b at Feb 15, 2011 at 4:55 am
    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 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, 안의건 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)
  • 안의건 at Feb 17, 2011 at 1:47 pm
    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 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, 안의건 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)
  • Ajo Fod at Feb 17, 2011 at 1:53 pm
    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 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, 안의건 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)

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupuser @
categorieshive, hadoop
postedFeb 14, '11 at 11:41a
activeFeb 17, '11 at 1:53p
posts5
users3
websitehive.apache.org

3 users in discussion

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

People

Translate

site design / logo © 2021 Grokbase