导入hive
sqoop import --hive-import --connect jdbc:mysql://172.16.222.111:3306/el_company --username hadoop --password hadoop --table company --hive-database ods --hive-table company --fields-terminated-by ‘|’ -m 1
从hive导出到mysql
sqoop export --connect jdbc:mysql://172.16.222.111:3306/test --username hadoop --password hadoop --table all4 --export-dir ‘/user/hive/warehouse/ods.db/all2/*’ --input-null-string ‘\N’ --input-null-non-string ‘\N’ --fields-terminated-by ‘\001’
导入hive指定字段
sqoop import --hive-import --connect jdbc:mysql://172.16.222.111:3306/el_court --username hadoop --password hadoop --table court_cpws_ent --hive-database ycj --hive-table court_cpws_ent --fields-terminated-by ‘|’ -m 1 --columns ‘id,pname’
作者:玫瑰花的葬礼gg
来源:CSDN
原文:https://blog.csdn.net/qq_34318002/article/details/90445169
版权声明:本文为博主原创文章,转载请附上博文链接!