脚本内容:
export SQOOP_HOME=/home/software/sqoop-1.4.4.bin__hadoop-2.0.4-alpha
export PATH=
P
A
T
H
:
PATH:
PATH:SQOOP_HOME/bin
sqoop import
–connect jdbc:mysql://192.168.124.130:3306/test
–username root
–password root
–table testtable
–target-dir /sunjj/testtable5
–fields-terminated-by ‘|’
-m 1
–incremental lastmodified
–check-column create_time
–last-value ‘2019-01-01 00:00:00’
–merge-key id
报错:
查找好久,发现是1.4.4版本的sqoop不支持。该版本只支持sqoop merge时使用merge-key参数。更换成1.4.7版本后,以上脚本执行成功