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配置即可