[DRILL-950] Incorrect parsing of CSV files

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.1.0-m1
• Fix Version/s: 0.4.0
• Component/s: Storage - Text & CSV
• Assignee: Jacques Nadeau
• Reporter: Tomer Shiran
• Created: 11/Jun/14 16:53
• Updated: 23/Apr/15 17:30
• Resolved: 27/Jun/14 00:33

Description

CSV parsing is incorrect. Commas inside quotes should be part of the string and not delimiters. Example:

140210850,"SEX OFFENSES, FORCIBLE","FORCIBLE RAPE, BODILY FORCE",Thursday,03/06/2014,19:15,NORTHERN,NONE,1200 Block of FRANCISCO ST,-122.425463608081,37.8031020597099,"(37.8031020597099, -122.425463608081)"

Issue Links

• Is contained by: DRILL-972 delimiter should be optional in text storage engines