hive导出到mysql以及mysql导入到hive

hive导出到mysql：

/export/server/sqoop-1.4.7.bin__hadoop-2.6.0/bin/sqoop export --connect jdbc:mysql://10.99.118.207:3306/db_msg --username root --password 1003392478 --table tb_rs_sender_phone --export-dir /user/hive/warehouse/db_msg.db/tb_rs_sender_phone --input-fields-terminated-by "\001"

 

mysql导入到hive：

sqoop import --connect jdbc:mysql://10.99.118.207:3306/it --username root --password 1003392478 --table spark --hive-import -m 1 --driver com.mysql.jdbc.Driver