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.

Sqoop HDFS to Netezza Enconding Issue, Characters are being converted

Sqoop HDFS to Netezza Enconding Issue, Characters are being converted

I am trying to use Sqoop Export to Export Data from HDFS to Netezza table. And I am facing issue with few of french characters. I have table with just only one column and one row as mentioned below.

En fil métallique résistant mâchouillag
  • I am able to see this text without any issue in Hive Table and corresponding HDFS directory as well.
  • I am also able to insert this same line in Netezza table without any issue, so I know my Netezza database handles these character.

Problem: When I use sqoop to export these data to Netezza table, I get following row as compared to mentioned above.

En fil meÌtallique résistant maÌchouillag

It seems like there is any issue with the Netezza JDBC driver I am using to export, I should specify somewhere the encoding or something like that. However, I am not sure.

Could someone please let me know how to fix this issue.

Don't have an account?
Coming from Hortonworks? Activate your account here