sqoop系列-1.upsert

1、执行语句 sqoop export \   --D mapred.job.queue.name=default \   --driver com.mysql.jdbc.Driver \   --connect jdbc:mysql://namenode/database \   --username xx \   --password xx \   --table saas_fraud_account_detail \   --export-dir /user/data/hive/account_risk/saas_fraud_account_detail/dt=$date \   --input-lines-terminated-by '\t' \   --input-fields-terminated-by '\001' \   --input-null-string '\\N' \   --input-null-non-string '\\N' \   --update-key organization,appId,tokenId,groupId \   --update-mode allowinsert \ -m 2

2、错误 ERROR ： Mixed update/insert is not supported against the target database yet

3.解决方案 Solution： Get rid of --driver , then it will work.

去掉 --driver配置即可