sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gwen Shapira <gshap...@cloudera.com>
Subject Re: Cannot get Sqoop to work: error on the com.mysql.jdbc.Driver class driver.
Date Thu, 24 Jul 2014 19:45:41 GMT
Hi,

Can you install the driver in /var/lib/sqoop as explained in the CDH5 docs?
http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH5/latest/CDH5-Installation-Guide/cdh5ig_jdbc_driver_install.html

Pay attention to the ownership and permissions part.

It worked for me :)

Gwen


On Thu, Jul 24, 2014 at 11:53 AM, Sean Franks <seancfranks@gmail.com> wrote:

> Please help!
>
>
>
> Cannot get Sqoop to work: error on the *com.mysql.jdbc.Driver class
> driver. *
>
> *I followed the instructions in the O’Reilley Sqoop book on loading the
> jar file as best as I could: but those instructions call for placing the
> .jar file in the /lib directory for Sqoop. HOWEVER, the Cloudera 5
> installation I’m running doesn’t have a /lib directory, and the /conf file
> is a pointer to a Cloudera set of configurations. I went so far as to put
> the class driver and pointer to the .jar file into the Cloudera
> /opt/--/sqoop.properties file.(And I definitely re-started the Sqoop2
> server every time I made a change). Still doesn’t work. Following is the
> output from the sqoop import script from Ch. 2 of O’Reilley Sqoop book.*
>
> *Does anybody know what I need to do to get this driver class *
>
> *The tables are all created and populated from the SQL script made
> available by the authors via github.*
>
> sqoop import --connect jdbc:mysql://mysql.example.com/sqoop --username
> root --table cities
>
> Warning:
> /opt/cloudera/parcels/CDH-5.1.0-1.cdh5.1.0.p0.53/bin/../lib/sqoop/../ac
> cumulo does not exist! Accumulo imports will fail.
>
> Please set $ACCUMULO_HOME to the root of your Accumulo installation.
>
> 14/07/24 18:23:28 INFO sqoop.Sqoop: Running Sqoop version: 1.4.4-cdh5.1.0
>
> 14/07/24 18:23:28 INFO manager.MySQLManager: Preparing to use a MySQL
> streaming
> resultset.
>
> 14/07/24 18:23:28 INFO tool.CodeGenTool: Beginning code generation
>
> *14/07/24 18:23:29 ERROR sqoop.Sqoop: Got exception running Sqoop:
> java.lang.Runt
> imeException: Could not load db driver class: com.mysql.jdbc.Driver*
>
> *java.lang.RuntimeException: Could not load db driver class:
> com.mysql.jdbc.Drive
> *r
>
>         at
> org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:797)
>
>         at
> org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbc
> Manager.java:52)
>
>         at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:685)
>
>         at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:708)
>
>         at
> org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(Sqlger.java:243)
>
> at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:22 6)
>
>         at
> org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:347)
>
>         at
> org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1305)
>
>         at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1110)
>
>         at
> org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:96)
>
>         at
> org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:396)
>
>         at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:506)
>
>         at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
>
>         at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
>
>         at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
>
>         at org.apache.sqoop.Sqoop.runTool(Sqoop.java:222)
>
>         at org.apache.sqoop.Sqoop.runTool(Sqoop.java:231)
>
>         at org.apache.sqoop.Sqoop.main(Sqoop.java:240)
>
>
>
>
>
>
>
> [image: Signature0001]
>
>
>
> Sean Franks
>
> “With the addition of a well structured Big Data ecosystem to the Data
> Highway of an enterprise, Business Intelligence analytics will take a
> quantum leap forward.”
>
>
>

Mime
View raw message