sqoop_export_from_hive_to_mysql

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