参见:http://www.cloudera.com/documentation/enterprise/5-4-x/topics/cdh_ig_jdbc_driver_install.html
1.建目录
mkdir -p /var/lib/sqoop2
chown sqoop2:sqoop2 /var/lib/sqoop2
chmod 755 /var/lib/sqoop2
-
设置Mysql
download mysql jdbc driver from: 链接.
cp mysql-connector-java-5.1.38-bin.jar /var/lib/sqoop2/
chown sqoop2:sqoop2 /var/lib/sqoop2/mysql-connector-java-5.1.38-bin.jar -
设置oracle
下载 oracle jdbc driver: 链接
cp ojdbc6.jar /var/lib/sqoop2/ojdbc6.jar
chown sqoop2:sqoop2 /var/lib/sqoop2/ojdbc6.jar -
sql server
下载:链接
cp sqljdbc4.jar /var/lib/sqoop2/
chown sqoop2:sqoop2 /var/lib/sqoop2/sqljdbc4.jar -
restart sqoop2 服务
最后,一定要小心的是,上述动作一定要在sqoop2安装的机器上进行,不要搞错了机器。这是近常犯的错误!!
网友评论