[DRILL-6958] CTAS csv with option

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.15.0, 1.16.0
• Fix Version/s: 1.17.0
• Component/s: Storage - Text & CSV
• Assignee: Unassigned
• Reporter: benj
• Created: 09/Jan/19 15:48
• Updated: 22/Oct/19 10:20
• Resolved: 22/Oct/19 10:20

Description

Currently, it may be difficult to produce well-formed CSV with CTAS (see comment below).

It appears necessary to have some additional/configuratble options to write CSV file with CTAS :

• possibility to change/define the separator,
• possibility to write or not the header,
• possibility to force the write of only 1 file instead of lot of parts,
• possibility to force quoting
• possibility to use/change escape char
• ...

Issue Links

• relates to: DRILL-6096 Provide mechanisms to specify field delimiters and quoted text for TextRecordWriter