sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sambit Tripathy (RBEI/PJ-NBS)" <Sambit.Tripa...@in.bosch.com>
Subject RE: Sqoop connector configuration
Date Thu, 25 Sep 2014 22:47:37 GMT
Many thanks Gwen and Abey.


-----Original Message-----
From: Gwen Shapira [mailto:gshapira@cloudera.com] 
Sent: Thursday, September 25, 2014 3:18 PM
To: user@sqoop.apache.org
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)
<Sambit.Tripathy@in.bosch.com> 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.
>
>
Mime
View raw message