1.在Hive上查看表的存储路径:show create table tablename
2.在hdfs上将路径复制到Linux本地:
sudo -u user hadoop fs -get /.../part-00000 /localpath/part-00000
3.将拷贝下来的数据导入Mysql:
mysql -h host -u user -P 3321 -D db -ppassword --default-character-set=utf8 --local-infile