[ https://issues.apache.org/jira/browse/HIVE-3065?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Brock Noland resolved HIVE-3065. -------------------------------- Resolution: Duplicate This is a duplicate of HIVE-1608. There is a very easy work around for this bug, setting "hive.query.result.fileformat" to "SequenceFile". > New lines in columns can cause problems even when using sequence files > ---------------------------------------------------------------------- > > Key: HIVE-3065 > URL: https://issues.apache.org/jira/browse/HIVE-3065 > Project: Hive > Issue Type: Bug > Affects Versions: 0.7.1, 0.8.1 > Reporter: Joey Echeverria > > When using sequence files as the container format, I'd expect to be able to > embed new lines in a column. However, this causes problems when the data is > output if the newlines aren't manually stripped or escaped. This tends to > show up as each row of output generating two (or more) rows with nulls after > the column with a new line and nulls for the "empty" columns on the second > row. -- This message was sent by Atlassian JIRA (v6.2#6252)