Hive - Special characters from csv file

[#1]

Hi All,

I am reading a csv file with special characters

I have tried the option but the special characters still show up in hive as ? in a diamond shape.

CREATE EXTERNAL TABLE

)

.......

)

ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
WITH SERDEPROPERTIES
(
'quoteChar'='"',
'separatorChar'=',',
'serialization.encoding'='windows-1252'
)
STORED AS TEXTFILE
LOCATION '..................';
TBLPROPERTIES('serialization.encoding'='windows-1252');

In csv file:

Not sure what else to do

Appreciate your help!

[#2]

@Venk123 I think you are hitting https://issues.apache.org/jira/browse/HIVE-3363

I would request to raise case to get it verified and if verified you would receive a patch.