Home | About | Sematext search-lucene.com search-hadoop.com
 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
Christopher Jones 2013-11-13, 18:04
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