Hello all, I'm having a problem with exporting UTF8 data from Hive into MySQL.
I can see the data is UTF8 in Hive but when Sqoop exports, I notice it replaces the UTF8 characters with question marks. I was able to copy one of the chunk files (16MB) from the mysqlimport command and verify this in the raw text file. I tried setting [client] default-character-set = utf8 in the /etc/mysql/my.cnf but then noticed the mysqlimport command uses a my.cnf file of its own (eg. mysql-cnf4015877111230439084.cnf) which does not have this. I feel like I'm missing something obvious. Any suggestions? Thanks
