Cloudera Community
Venk123
user rank
New Contributor

Hive - Special characters from csv file

by New Contributor in Support Questions
‎09-27-2021 11:39 PM
‎09-27-2021 11:39 PM
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! ... View more
Labels:

Re: Why hive is not able to store special characte...

by New Contributor in Support Questions
‎09-27-2021 09:58 PM
‎09-27-2021 09:58 PM
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');     Not sure what else to do ... View more
Contact Me
Online
Offline
Last Visited
‎09-28-2021 01:19 AM
Community Statistics
Member Since ‎09-27-2021 09:53 PM
Last Visited ‎09-28-2021 01:19 AM
Posts 2