- 创建JOB
sqoop job -D mapreduce.job.queuename='root.bi' --create xt_test_job -- import --connect jdbc:mysql://xxxx:3306/test?tinyInt1isBit=false --username xxx --password xxx --table bi_c2c_appoint_task --incremental "lastmodified" --check-column "a_updated_at" --hcatalog-database test --hcatalog-table xt_test_job_tbl --hcatalog-storage-stanza 'stored as orcfile' -m 1
- 运行JOB
sqoop job -D mapreduce.job.queuename='root.bi' --exec xt_test_job -- --columns 'id,car_source_id,appoint_address,a_updated_at' --hcatalog-partition-keys dt,dh --hcatalog-partition-values 2018-04-25,13
- 显示JOB
sqoop job --show xt_test_job