Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
Sqoop >> mail # user >> Sqoop 2 Oracle JDBC connector not visible / available


Copy link to this message
-
Sqoop 2 Oracle JDBC connector not visible / available
Hi Sqoopers,

I'm using Sqoop 2 and am trying to transfer some Oracle 11g tables to HDFS.
 I believe I have the jar file where it's supposed to be:

]$ ls /var/lib/sqoop2/ojdbc6-11.2.0.3.jar
/var/lib/sqoop2/ojdbc6-11.2.0.3.jar

and it's a non-empty file.  I tried to make sure the jar was on the
$CLASSPATH too:

$ echo $CLASSPATH
/etc/hadoop/conf:/usr/lib/hadoop/lib/*:/usr/lib/hadoop/.//*:/usr/lib/hadoop-hdfs/./:/usr/lib/hadoop-hdfs/lib/*:/usr/lib/hadoop-hdfs/.//*:/usr/lib/hadoop-yarn/lib/*:/usr/lib/hadoop-yarn/.//*:/usr/lib/hadoop-0.20-mapreduce/./:/usr/lib/hadoop-0.20-mapreduce/lib/*:/usr/lib/hadoop-0.20-mapreduce/.//*:/var/lib/sqoop2/ojdbc6-11.2.0.3.jar

However, when I run sqoop2 at the command line, I can only see the generic
connector:

$ sqoop2
Sqoop home directory: /usr/lib/sqoop2
Sqoop Shell: Type 'help' or '\h' for help.

sqoop:000> show connector --all
1 connector(s) to show:
Connector with id 1:
  Name: generic-jdbc-connector
 Class: org.apache.sqoop.connector.jdbc.GenericJdbcConnector
  Version: 1.99.2-cdh4.4.0
  Supported job types: [IMPORT, EXPORT]
(...)

Shouldn't I be seeing the Oracle connector as well?

I'm using the following version:

sqoop:000> show version
client version:
  Sqoop 1.99.2-cdh4.4.0 revision
  Compiled by jenkins on Tue Sep  3 20:15:11 PDT 2013

Thanks for your help, and for all the hard work,
Chris
+
Jarek Jarcec Cecho 2013-11-13, 22:23
+
Christopher Jones 2013-11-15, 15:36
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB