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

发布时间 2023-09-20 23:41:16作者: Joranger
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