[HIVE-8615] beeline csv,tsv outputformat needs backward compatibility mode

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 0.14.0
• Fix Version/s: 0.14.0
• Component/s: Beeline

Release Note

The formats csv, tsv have been deprecated. The use of csv2 and tsv2 is recommended in place of them.

- Old format quoted every field. New format quotes only fields that contain a delimiter or the quoting char.
- Old format quoted using single quotes, new format quotes using double quotes
- Old format didn't escape quotes in a field (a bug). New format does escape the quotes

• Assignee: Thejas Nair
• Reporter: Thejas Nair
• Created: 27/Oct/14 19:15
• Updated: 09/Oct/16 06:17
• Resolved: 29/Oct/14 05:53

Description

Changes in HIVE-7390 break backward compatibility for beeline csv and tsv formats.
This can cause problems for users upgrading to hive 0.14, if they have code for parsing the old output format. Instead of removing the old format in this release, we should consider it deprecated and support it in a few releases before removing it completely.

Incompatible Changes in the tsv and csv formats-

• Old format quoted every field. New format quotes only fields that contain a delimiter or the quoteing char.
• Old format quoted using single quotes, new format quotes using double quotes
• Old format didn't escape quotes in a field (a bug). New format does escape the quotes

Issue Links

• contains: HIVE-8544 Beeline SeparatedValuesOutputFormat (csv/tsv/dsv) wraps the results with extra double quotes
• is broken by: HIVE-7390 Make single quote character optional and configurable in BeeLine CSV/TSV output
• is related to: HIVE-14632 beeline outputformat needs better documentation
• supercedes: HIVE-8544 Beeline SeparatedValuesOutputFormat (csv/tsv/dsv) wraps the results with extra double quotes
• links to: Review Board