sqoop export
--connect jdbc:mysql://smartbi.mysql.com:3306/bidata
--username rootusr
--password rootusr
--table app_bi_f_dqyhmxb
--export-dir /warehouse/tablespace/managed/hive/app.db/app_bi_f_dqyhmxb/dayid=$1/*/*
--input-fields-terminated-by '^'
--columns 'datatype,settledate,yhdqxz,shengfbm,shengf,qiybm,date_insert'
--update-key qiybm,settleDate --update-mode allowinsert
--m 1
