Many thanks Gwen and Abey.
-----Original Message----- From: Gwen Shapira [mailto:[email protected]] Sent: Thursday, September 25, 2014 3:18 PM To: [email protected] Subject: Re: Sqoop connector configuration Sqoop2 does not have specific connectors for Oracle and Netezza yet. Its not you, its us :) Suggestions: 1. Use Sqoop2 with the generic JDBC connector 2. Use Sqoop 1.4.X with the Oracle and Netezza connectors. Gwen On Thu, Sep 25, 2014 at 3:06 PM, Sambit Tripathy (RBEI/PJ-NBS) <[email protected]> wrote: > Hi, > > I have recently upgraded my cluster to CDH 5.1 and Sqoop2. > > My Sqoop 2 server is “sqoop-server-main” > > 1. On “sqoop-server-main” I have copied “ojdbc6.jar” and > “mysql-connector-java-version-bin.jar” to /var/lib/sqoop2/ > > 2. Restarted the Sqoop2 service > > 3. To verify I logged in to “sqoop-server-main” and typed “sqoop2” to get > into the sqoop shell which worked. > > 4. Now to see the available connectors I typed “show connector --all” > > I get > > 1 connector(s) to show: > Connector with id 1: > Name: generic-jdbc-connector > Class: org.apache.sqoop.connector.jdbc.GenericJdbcConnector > Version: 1.99.3-cdh5.1.0 > > > I am not able to figure out what has gone wrong here! I should see both > oracle and mysql connectors along with the generic-jdbc-driver. > > Are there any config changes required? As I understand in Sqoop 2 the > connectors/drivers should be present on the server in contrast with Sqoop 1 > > I always appreciate your suggestions and pointers. > > > Regards, > Sambit. > >
