Raj created SPARK-26804:
---------------------------

             Summary: 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


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: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to