[jira] [Commented] (SPARK-26040) CSV Row delimiters not consistent between platforms

["Hyukjin Kwon (JIRA)" <ji...@apache.org>]

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

Hyukjin Kwon commented on SPARK-26040:
--------------------------------------

I think this is not an issue when {{multiLine}} is disabled because we delegate newline handling to Hadoop library which deals with both cases.
The problem is when {{multiLine}} is enabled. This case is fixed in https://github.com/apache/spark/pull/22503

This should be a duplicate of SPARK-25493

> CSV Row delimiters not consistent between platforms
> ---------------------------------------------------
>
>                 Key: SPARK-26040
>                 URL: https://issues.apache.org/jira/browse/SPARK-26040
>             Project: Spark
>          Issue Type: Bug
>          Components: Java API
>    Affects Versions: 2.3.0
>            Reporter: Heath Abelson
>            Priority: Major
>
> Running a spark job on *nix platforms, only unix style row delimiters (\n) are recognized. When running the job on windows, only windows style delimiters are recognized (\r\n).
> The result is that, when trying to read a csv generated my MS excel, on spark running on Linux, extra characters are included in field names and field values that are last on the line.
> Ideally, the CSV parser would be able to handle the 2 different flavors of line endings regardless of what platform the job is being run on.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

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