Thanks,
This is one of the solutions I have in mind, but this requires input to
change it's format, it will be very unreadable by human.
Another solution I'm considering is to just remove \n from fields and
replace them with for example '<br>' or anything.
On 07.09.2011 18:55, Travis Powell wrote:
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 / tpow...@tealeaf.com
Tealeaf Technology / http://www.tealeaf.com
-----Original Message-----
From: Wojciech Langiewicz [mailto:wlangiew...@gmail.com]
Sent: Wednesday, September 07, 2011 4:31 AM
To: user@hive.apache.org
Subject: how to store EOL characters in String field?
Hello,
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
--
Wojciech Langiewicz
