sqoop把hive数据导入mysql出现中文乱码

vim /etc/my.cnf

init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake

systemctl restart mysqld.service（我这里centos7）
或
service mysqld restart（centos6）

sqoop-export \
--connect "jdbc:mysql://localhost:3306/lft?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456 \
--table test3 \
--export-dir /user/hive/warehouse/hadoop.db/test3 \
--input-fields-terminated-by '\001';

set character_set_database=utf8;
set character_set_server=utf8;