Fork me on GitHub

sqoop之旅7-sqoop job

sqoop job

Purpose

The job tool allows you to create and work with saved jobs. Saved jobs remember the parameters used to specify a job, so they can be re-executed by invoking the job by its handle.

If a saved job is configured to perform an incremental import, state regarding the most recently imported rows is updated in the saved job to allow the job to continually import only the newest rows.

  • 通过已经保存好的作业直接执行以前的任务,无需重复操作

  • 记录sqoop命令的配置信息

  • saved job保证只导入最新的数据

Syntax

1
2
$ sqoop job (generic-args) (job-args) [-- [subtool-name] (subtool-args)]
$ sqoop-job (generic-args) (job-args) [-- [subtool-name] (subtool-args)]

MfIrzF.png

看一个demo

1
2
3
4
5
6
7
8
9
10
11
12
13
14
# 创建
sqoop job --create myjob \ # 指定名字myjob
-- import \
--connect jdbc:mysql://ubuntu:3306/sqooptest \
--table mytable

# 执行
sqoop job --exec myjob -- --username root -P # 接下来需要输入密码

# 显示
sqoop job --list

# 查看
sqoop job --show myjob

本文标题:sqoop之旅7-sqoop job

发布时间:2019年11月20日 - 19:11

原始链接:http://www.renpeter.cn/2019/11/20/sqoop%E4%B9%8B%E6%97%857-sqoop-job.html

许可协议: 署名-非商业性使用-禁止演绎 4.0 国际 转载请保留原文链接及作者。

Coffee or Tea