[
https://issues.apache.org/jira/browse/SPARK-26804?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Raj updated SPARK-26804:
------------------------
Attachment: image-2019-02-04-12-28-21-117.png
> Spark sql carries newline char from last csv column when imported
> -----------------------------------------------------------------
>
> Key: SPARK-26804
> URL: https://issues.apache.org/jira/browse/SPARK-26804
> Project: Spark
> Issue Type: Bug
> Components: Spark Core
> Affects Versions: 2.4.0
> Reporter: Raj
> Priority: Major
> Attachments: TestFile.csv, image-2019-02-04-12-09-19-210.png,
> image-2019-02-04-12-28-21-117.png
>
>
> I am trying to generate external sql tables in DataBricks using Spark sql
> query. Below is my query. The query reads csv file and creates external table
> but it carries the newline char while creating the last column. Is there a
> way to resolve this issue?
>
> %sql
> create table if not exists <<My table name>>
> using CSV
> options ("header"="true", "inferschema"="true","multiLine"="true",
> "escape"='"')
> location <my csv path>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
