RE: line breaks
Don't use \n to terminate lines if your fields contain them. Use something else like \002 or \001
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\002';
...or something like that.
Travis Powell / [EMAIL PROTECTED]
Tealeaf Technology / http://www.tealeaf.com
From: Wojciech Langiewicz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 07, 2011 4:31 AM
To: [EMAIL PROTECTED]
Subject: how to store EOL characters in String field?
How can I store EOL characters in Hive in String field?
I'm using Hive 0.7 and I couldn't find anything about escaping or
enclosing field values.
I want to use <TAB> as field delimiter and lines are terminated by '\n'.
That causes issues, because part of text after '\n' is loaded as next
line, which is unreadable (all NULLs)
Thanks for help