sqoop job用法

  • 创建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

评论

暂无评论