Export the special characters using sqoop.

We are trying to export one tables from hive to MySQL using sqoop export.
Our hive table data contains the special characters like ... じゃあまた, どうぞ

The Sqoop Command we are using to export the data is.
sqoop export --verbose --connect jdbc:mysql://xx.xx.xx.xxx/mydb --username xyz --password xxxx --table mytable --direct --driver com.mysql.jdbc.Driver --export-dir /apps/hive/warehouse/mydb.db/mytable --fields-terminated-by ' '

With this command the data is stored in the form of question marks (?) not in form of actual message with special characters.Cane we export the special characters using sqoop.
Anybody please help me in storing the special characters.

Sign In or Register to comment.