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
