[jira] [Commented] (SPARK-21586) Read CSV (SQL Context) Doesnt ignore delimiters within special types of quotes, other special characters

["Sean Owen (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SPARK-21586?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16108471#comment-16108471 ] 

Sean Owen commented on SPARK-21586:
-----------------------------------

Give an example of the input and how you read it. It is not clear that your input is valid and that you configured to read it correctly. 

> Read CSV (SQL Context) Doesnt ignore delimiters within special types of quotes, other special characters
> --------------------------------------------------------------------------------------------------------
>
>                 Key: SPARK-21586
>                 URL: https://issues.apache.org/jira/browse/SPARK-21586
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 2.2.0
>            Reporter: Balasubramaniam Srinivasan
>
> The read csv command doesn't ignore commas in specific cases like when a dictionary is an entry in a column, other examples include when we have double quotes - for example if this is an entry in a column "Here we go"""This is causing a problem, but is handled well in pandas""" There!". In the case pandas treats this well as just one entry, but the delimiter doesnt work well in spark dataframes



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org