FAQ
I have a pig statement which works fine :
raw_data = LOAD '$input_path' USING PigStorage*('\u0002'*) AS ...

And I am trying to use the corresponding hive QL :
CREATE EXTERNAL TABLE tx_log(......)
ROW FORMAT DELIMITED FIELDS TERMINATED BY *'\u0002'*
STORED AS TEXTFILE
LOCATION '/ip/data/tx_log_1';

This doesnt work. Any quick pointers on what should be the corresponding
unicode representation ( for *'\u0002' ) * in hive ?

-Prasen

Search Discussions

  • Eric Arenas at Feb 16, 2010 at 8:08 pm
    Hi Prasen,

    this should work... (I use CTRL+A as delimiter)

    hive> create table test_ea (col1 string) row format delimited fields terminated by '\001' stored as textfile;


    In your case, '\002' should work.

    regards
    Eric Arenas




    ________________________________
    From: prasenjit mukherjee <pmukherjee@quattrowireless.com>
    To: hive-user <hive-user@hadoop.apache.org>
    Sent: Tue, February 16, 2010 4:43:07 AM
    Subject: Fields delimited by unicode chars

    I have a pig statement which works fine :
    raw_data = LOAD '$input_path' USING PigStorage('\u0002') AS ...

    And I am trying to use the corresponding hive QL :
    CREATE EXTERNAL TABLE tx_log(......)
    ROW FORMAT DELIMITED FIELDS TERMINATED BY '\u0002'
    STORED AS TEXTFILE
    LOCATION '/ip/data/tx_log_1';

    This doesnt work. Any quick pointers on what should be the corresponding unicode representation ( for '\u0002' ) in hive ?

    -Prasen

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupuser @
categorieshive, hadoop
postedFeb 16, '10 at 12:43p
activeFeb 16, '10 at 8:08p
posts2
users2
websitehive.apache.org

People

Translate

site design / logo © 2022 Grokbase