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');
![Venk123_1-1632811054994.png Venk123_1-1632811054994.png](https://community.cloudera.com/t5/image/serverpage/image-id/32463i5223387F4F6375FB/image-size/medium?v=v2&px=400)
In csv file:
![Venk123_0-1632811037456.png Venk123_0-1632811037456.png](https://community.cloudera.com/t5/image/serverpage/image-id/32462iAE7DB4DAF4E2A32E/image-size/medium?v=v2&px=400)
Not sure what else to do
Appreciate your help!