1、Sqoop从Hive导入Oracle
sqoop export \
--connect "jdbc:oracle:thin:@//IP:1521/orcl" \
--username "root" \
--password "123456" \
--table STG_ZFW_WANGGEXINXI \
--export-dir /user/hive/warehouse/mask_data.db/stg_zfw_wanggexinxi/* \
--columns XM,ZJHM,WANGGE,BUILDINGCODE,ADDRESSSTRING,LXFS \
--input-fields-terminated-by '|' \
--input-lines-terminated-by '\n' \
--input-null-string "\\\\N" \
--input-null-non-string "\\\\N" \
-m 8