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