[ 
https://issues.apache.org/jira/browse/SPARK-33501?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Nilesh Patil updated SPARK-33501:
---------------------------------
    Description: 
If we read with mulitLine true and encoding with "ISO-8859-1" then we are 
getting  value like this {color:#ff0000}AUTO EL*�*TRICA{color}. and if we read 
with multiLine false  and encoding with "ISO-8859-1" thne we are getting  value 
like {color:#ff0000}AUTO EL*É*TRICA{color}

Below is the code we are using

Dataset<Row> dataset1 = SparkUtil.getSparkSession().read().Dataset<Row> 
dataset1 = SparkUtil.getSparkSession().read(). option("header", "true"). 
option("inferSchema", true). option("delimiter", ";") .option("quote", "\"") 
.option("multiLine", true) .option("encoding", "ISO-8859-1") .csv("file path");

dataset1.show();

Sample file is attached in attachement 

  was:
If we read with mulitLine true and encoding with "ISO-8859-1" then we are 
getting  value like this {color:#FF0000}AUTO EL*�*TRICA{color}. and if we read 
with multiLine false  and encoding with "ISO-8859-1" thne we are getting  value 
like {color:#FF0000}AUTO EL*É*TRICA{color}

Below is the code we are using

Dataset<Row> dataset1 = SparkUtil.getSparkSession().read().Dataset<Row> 
dataset1 = SparkUtil.getSparkSession().read(). option("header", "true"). 
option("inferSchema", true). option("delimiter", ";") .option("quote", "\"") 
.option("multiLine", true) .option("encoding", "ISO-8859-1") .csv("file path");

dataset1.show();

 


> Encoding is not working if multiLine option is true.
> ----------------------------------------------------
>
>                 Key: SPARK-33501
>                 URL: https://issues.apache.org/jira/browse/SPARK-33501
>             Project: Spark
>          Issue Type: Bug
>          Components: Spark Core
>    Affects Versions: 2.3.4
>            Reporter: Nilesh Patil
>            Priority: Major
>         Attachments: 1605860036183.csv
>
>
> If we read with mulitLine true and encoding with "ISO-8859-1" then we are 
> getting  value like this {color:#ff0000}AUTO EL*�*TRICA{color}. and if we 
> read with multiLine false  and encoding with "ISO-8859-1" thne we are getting 
>  value like {color:#ff0000}AUTO EL*É*TRICA{color}
> Below is the code we are using
> Dataset<Row> dataset1 = SparkUtil.getSparkSession().read().Dataset<Row> 
> dataset1 = SparkUtil.getSparkSession().read(). option("header", "true"). 
> option("inferSchema", true). option("delimiter", ";") .option("quote", "\"") 
> .option("multiLine", true) .option("encoding", "ISO-8859-1") .csv("file 
> path");
> dataset1.show();
> Sample file is attached in attachement 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

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

Reply via email to