sqoop import \
-Dmapreduce.job.queuename=root.mda \
--connect 'jdbc:jtds:sqlserver://SGH1PDWBIDBV06.cn.yumchina.com:55650/SQL2008_DWBI06;domain=YumChina;databasename=DWBI2_Delivery_PHHS;sendStringParametersAsUnicode=false' \
--username serv-bda-prd \
--password "%h\wd\4+" \
--query " select min(date_key) as mindate,max(date_key) as maxdate,count(*) as total from raw.t_fact_tld_header_source where \$CONDITIONS " \
--mapreduce-job-name sqoop_import_raw_t_fact_tld_header_source \
--delete-target-dir \
--target-dir "/apps/hive/warehouse/staging/ph/raw_t_fact_tld_header_source" \
--null-non-string '\\N' --null-string '\\N' --fields-terminated-by '\034' \
--hive-drop-import-delims \
-m 1
版权声明：本文为hetry_liang原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。