sqoop同步命令从mysql同步到hive-Toy模板网

这篇具有很好参考价值的文章主要介绍了sqoop同步命令从mysql同步到hive。希望对大家有所帮助。如果存在错误或未考虑完全的地方，请大家不吝赐教，您也可以点击"举报违法"按钮提交疑问。

sqoop import --connect jdbc:mysql://192.168.253.142:8066/youfanshop --username mycat --password 123456 --query 'SELECT id,name,age,address,telphone,qq,weixin,email,sex,birthday,account FROM user WHERE $CONDITIONS' --fields-terminated-by '\t' --null-string '**' --target-dir /user/hive/warehouse/youfanshop.db/user --hive-table youfanshop.user --m 1 --hive-import

sqoop import --connect jdbc:mysql://192.168.253.142:8066/youfanshop --username mycat --password 123456 --table producttype --fields-terminated-by '\t' --null-string '**' --target-dir /user/hive/warehouse/youfanshop.db/producttype --hive-table youfanshop.producttype --m 1 --hive-import

sqoop import --connect jdbc:mysql://192.168.253.142:8066/youfanshop --username mycat --password 123456 --table productdetail --fields-terminated-by '\t' --null-string '**' --target-dir /user/hive/warehouse/youfanshop.db/productdetail --hive-table youfanshop.productdetail --m 1 --hive-import

sqoop import --connect jdbc:mysql://192.168.253.142:8066/youfanshop --username mycat --password 123456 --table product --fields-terminated-by '\t' --null-string '**' --m 1 --target-dir /user/hive/warehouse/youfanshop.db/product --hive-table youfanshop.product --hive-import

sqoop import --connect jdbc:mysql://192.168.253.142:8066/youfanshop --username mycat --password 123456 --table ordermain --fields-terminated-by '\t' --null-string '**' --m 1 --target-dir /user/hive/warehouse/youfanshop.db/ordermain --hive-table youfanshop.ordermain --hive-import

sqoop import --connect jdbc:mysql://192.168.253.142:8066/youfanshop --username mycat --password 123456 --table orderdetail --fields-terminated-by '\t' --null-string '**' --m 1 --target-dir /user/hive/warehouse/youfanshop.db/orderdetail --hive-table youfanshop.orderdetail --hive-import

sqoop import --connect jdbc:mysql://192.168.253.142:8066/youfanshop --username mycat --password 123456 --query 'SELECT id ,merchantname ,merchantshopname ,merchantaccount ,mechantscope FROM mechant WHERE $CONDITIONS' --fields-terminated-by '\t' --null-string '**' --m 1 --target-dir /user/hive/warehouse/youfanshop.db/mechant --hive-table youfanshop.mechant --hive-import
文章来源地址https://www.toymoban.com/news/detail-741563.html

到了这里，关于sqoop同步命令从mysql同步到hive的文章就介绍完了。如果您还想了解更多内容，请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章，希望大家以后多多支持TOY模板网！