sqoop job --create job_2 – import --connect ‘jdbc:mysql://sunchen11/hadoopguide’ --username root --password root --table widgets -m 1 --target-dir --target-dir /sqoop/test/djt_user --append --check-column ‘id’ --incremental append --last-value 1
sqoop import \
--connect jdbc:mysql://hadoop202:3306/db02 \
--username tim \
--password 123456 \
--table emp \
--target-dir /mysqoop/emp \
--delete-target-dir \
--fields-terminated-by "\t" \
--num-mappers 2 \
--split-by id \
--columns 'id , name' \
--where 'id >= 5 and id <= 9' //换行符\与其它字段是空格间隔,大小写敏感
[bai@hadoop202 lib]$ hdfs dfs -cat '/mysqoop/emp/part-m-00001'