How can we preserve newlines in data in Hive columns? Currently newlines in data terminate the Hive record.
I am using Sqoop to import data into Hive from external databases. Even using the the Escaped By clause of CREATE TABLE, Hive does not escape newlines. I see there is a JIRA for this https://issues.apache.org/jira/browse/HIVE-1898 . I'm wondering how others deal with preserving newlines? Is there any way short of replacing all newlines before importing? Is there a custom input format class that can use a different line terminator?
