目录:
文章目录
#一、最简单的job作业
##1、创建一个job
将mysql中为emp表的数据导入到hdfs上
注意:在创建job时,命令"-- import" 中间有个空格,切勿忽视,否则报错!
sqoop job \
--create firstJob \
-- import \
--connect jdbc:mysql://mini1:3306/emp_db \
--username root \
--password root \
--table emp \
--target-dir /emp_db/firstJob
--m 1
##2、验证作业是否创建成功
运行如下命令,显示
Available jobs:
firstJob
sqoop job --list
##3、根据job名称查看某一个具体的job信息
运行如下命令,中间提示输入密码,查看具体信息
sqoop job --show firstJob
Enter password:
Job: firstJob
Tool: import
Options:
----------------------------
verbose = false
hcatalog.drop.and.create.table = false
db.connect.string = jdbc:mysql://mini1:3306/emp_db
codegen.output.delimiters.escape = 0
codegen.output.delimiters.enclose.required = false
codegen.input.delimiters.field = 0
split.limit = null
hbase.create.table = false
mainframe.input.dataset.type = p
db.require.password = true
skip.dist.cache = false
hdfs.append.dir = false
db.table = emp
codegen.input.delimiters.escape = 0
accumulo.create.table = false
import.fetch.size = null
codegen.input.delimiters.enclose.required = false
db.username = root
reset.onemapper = false
codegen.output.delimiters.record = 10
import.max.inline.lob.size = 16777216
sqoop.throwOnError = false
hbase.bulk.load.enabled = false
hcatalog.create.table = false
db.clear.staging.table = false
codegen.input.delimiters.record = 0
enable.compression = false
hive.overwrite.table = false
hive.import = false
codegen.input.delimiters.enclose = 0
accumulo.batch.size = 10240000
hive.drop.delims = false
customtool.options.jsonmap = {}
codegen.output.delimiters.enclose = 0
hdfs.delete-target.dir = false
codegen.output.dir = .
codegen.auto.compile.dir = true
relaxed.isolation = false
mapreduce.num.mappers = 1
accumulo.max.latency = 5000
import.direct.split.size = 0
sqlconnection.metadata.transaction.isolation.level = 2
codegen.output.delimiters.field = 44
export.new.update = UpdateOnly
incremental.mode = None
hdfs.file.format = TextFile
sqoop.oracle.escaping.disabled = true
codegen.compile.dir = /tmp/sqoop-root/compile/137b9999fcfa09bf41737adbc34d9803
direct.import = false
temporary.dirRoot = _sqoop
hdfs.target.dir = /emp_db/firstJob
hive.fail.table.exists = false
db.batch = false
##3、执行job
运行如下命令,执行一个job,中间需要输入密码
sqoop job --exec firstJob
##4、删除job
运行如下命令删除一个job,在用命令sqoop job --list查看job,确认已经删除
sqoop job --delete firstJob