Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to Escaping double quotes in CSV file and stored as HIVE ORC format ?

Highlighted

How to Escaping double quotes in CSV file and stored as HIVE ORC format ?

New Contributor

I have a data in CSV format and column value contains double quotes and special characters. While writing into hive as orc format, I am seeing null and question marks (special characters). Any help will be appreciated.

ColumnA|ColumnB|ColumnC

10007|"Conversion on the" test| Ã_Test

10056|"CHJJJe" test| Ã_Test

10066|"keep alive until on the" test| Ã_Test

Output shows

10007|nul| �_Test

10056|nul| �_Test

10066|nul| �_Test