Yes this is a known issue. "lines terminated by" is not supported yet
because the text input format do not allow configurable line
separators yet.


Zheng


On 2/24/09, Johan Oskarsson <[email protected]> wrote:
> I've been trying to use a text file with the field separator \001 and
> line separator \002\n in Hive, similar to what's described here
> http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL.
>
> I've set the "lines terminated by" to \002 but when selecting data the
> last column still includes that character, if the last col is a string.
> If it's an int the value fails to parse and is left as null.
>
> Is this a known issue? I can't find a ticket for it.
> I assume the TextInputFormat takes care of the \n so that I only need to
> use \002 as the termination.
>
> Example create queries
>
> create table artistsong (export_date bigint, artist_id int, song_id int)
> ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' lines terminated by '\002'
>
> and this one:
>
> create table artist (export_date bigint, artist_id int, name string,
> is_actual_artist int, view_url string) ROW FORMAT DELIMITED FIELDS
> TERMINATED BY '\001' lines terminated by '\002'
>
> /Johan
>

-- 
Sent from Gmail for mobile | mobile.google.com

Yours,
Zheng

Reply via email to