[HIVE-3065] New lines in columns can cause problems even when using sequence files

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 0.7.1, 0.8.1
• Assignee: Unassigned
• Reporter: Joey Echeverria
• Created: 30/May/12 14:44
• Updated: 06/Apr/14 13:49
• Resolved: 06/Apr/14 13:49

Description

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.

Issue Links

• relates to: HIVE-1598 use SequenceFile rather than TextFile format for hive query results
• relates to: HIVE-1608 use sequencefile as the default for storing intermediate results