sqoop从pg导出数据到hadoop上
/opt/sqoop/bin/sqoop import -D mapred.job.name=pg2hadoop -m 1 --connect “jdbc:postgresql://10.188.6.91:5432/postgres” --username root --password “3^240606” —non-string “” —string “”
–query "SELECT branch_code, branch_name, full_path_name, parent_code, short_name, cons_flag, cons_flag_name, org_type_cd, belong_level, opt_start_time, l1_branch_code, l2_branch_code, manual_flag, seq_num, manager_id, leader_id, src_sys, is_active FROM ri_base.ri_base_auth_biz_branch where $CONDITIONS "
–target-dir ${DMP_RISK}/tmp/riskctr/ri_base_auth_biz_branch/20250122 --delete-target-dir