Oozie中添加sqoop用到的jdbc包

CDH5中，在oozie中执行sqoop命令时，可能需要手动添加一些jdbc包。

将jar包放置到hdfs中lib目录

1
/user/oozie/share/lib/lib_${timestamp}/sqoop

然后使用oozie的sharelibupdate命令更新

1
2
3
4
5
6
$ oozie admin -oozie http://192.168.0.100:11000/oozie -sharelibupdate
[ShareLib update status]
	sharelibDirOld = hdfs://nameservice/user/oozie/share/lib/lib_20160801151935
	host = http://192.168.0.100:11000/oozie
	sharelibDirNew = hdfs://nameservice/user/oozie/share/lib/lib_20160801151935
	status = Successful

参考

  1. cloudera: How-to: Use the ShareLib in Apache Oozie (CDH 5)
  2. Oozie: Command Line Interface Utilities
  3. StackOverflow: Oozie + Sqoop: JDBC Driver Jar Location