sqoop 的job使用方式及密码保存

sqoop 的job使用方式

基本使用说明

job参数说明

功能简单明了。

Argument	Description
--create <job-id>	Define a new saved job with the specified job-id (name). A second Sqoop command-line, separated by a -- should be specified; this defines the saved job.
--delete <job-id>	Delete a saved job.
--exec <job-id>	Given a job defined with --create, run the saved job.
--show <job-id>	Show the parameters for a saved job.
--list	List all saved jobs

创建job

$ sqoop job --create myjob \
    -- import --connect jdbc:mysql://example.com/db \
    --table mytable \

注意这里有个坑，-- import之间有个空格。这里–空格之后表示给job添加参数，而恰好import又不需要–，所以这个空格很容易被忽略。

查看job

[admin@centos7x3 software]$ sqoop job --list
2019-12-20 14:09:47,971 INFO sqoop.Sqoop: Running Sqoop version: 1.4.7
Available jobs:
  myjob

显示job

[admin@centos7x3 software]$ sqoop job --show myjob
2019-12-20 13:10:51,328 INFO sqoop.Sqoop: Running Sqoop version: 1.4.7
Job: myjob
Tool: import
Options:
----------------------------
verbose = false
hcatalog.drop.a