问题描述
我正在使用Hortonworks HDP沙箱，并且已按照说明安装了Oraoop，但是每当运行Sqoop导入时，都会收到消息"oracle.OraOopManagerFactory:Oracle和Hadoop的数据连接器已禁用.".我不确定要拿起它还需要做什么.我已验证oraoop驱动程序在我的sqoop lib目录中.导入确实可以，但是它们只是使用oracle驱动程序，我想体验一下Oraoop所提供的一些功能.
I'm using the Hortonworks HDP Sandbox, and I’ve installed Oraoop per the instructions, but whenever I run a Sqoop import I get the message "oracle.OraOopManagerFactory: Data Connector for Oracle and Hadoop is disabled.". I’m not sure what else I need to do for it to pick it up. I have verified that the oraoop driver is in my sqoop lib directory. The imports do work, but they are just using the oracle driver, and I would like to play around with some of the features that you get with Oraoop.
这是我正在运行的命令:
This is the command I'm running:
sqoop-import --connect jdbc:oracle:thin:@<ip>:1521/sid --username myUser -P --query "select * from mytable where \$CONDITIONS" -split-by sequence_id -as-sequencefile --target-dir /user/hue/data/deactivatedsponsor
推荐答案
如果在'--table'参数中指定了'--query'参数，则不使用Oraoop连接器. Sqoop文档
If '--query' argument is specified in place of '--table' parm, Oraoop connector is not used.Following is mentioned in Sqoop Documentation
与Oracle有关
基于表格-使用table参数且指定对象是表格的作业.
Table-Based - Jobs where the table argument is used and the specified object is a table.
以下命令应使用Oraoop连接器.我已将"--direct"包括在内选项也向Sqoop指示应使用Oraoop.
Following command should use Oraoop Connector. I have included "--direct" option as well which indicates to Sqoop that Oraoop should be used.
sqoop-import --connect jdbc:oracle:thin:@<ip>:1521/sid --direct --username myUser -P --table mytable -split-by sequence_id -as-sequencefile --target-dir /user/hue/data/deactivatedsponsor --columns <columns list> --where <where condition if needed>
这篇关于禁用Oraoop进行Sqoop导入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！