Is the db drive jar on a classpath? try copying it to the lib folder in sqoop and try again.
*Alex Rovner *| Manager, Software Development Proclivity Media 22 W 19th Street 9th Floor New York NY 10011 p 646-237-3725 [email protected] www.proclivitymedia.com On Thu, Jun 7, 2012 at 7:26 AM, Amit S Namboothiry <[email protected]>wrote: > I've been trying to import a table from Vectorwise to Hive using Sqoop. > I downloaded the Vectorwise JDBC driver and all. It just ain't working. > > This is the command I'm using: > > sudo -u hdfs sqoop import --driver com.ingres.jdbc.IngresDriver --connect > jdbc:ingres://172.16.63.157:VW7/amit --username ingres -password ingres > --table vector_table --hive-table=vector_table --hive-import > --create-hive-table -m 1 > > And I'm getting the error: > > 12/06/07 22:08:27 ERROR sqoop.Sqoop: Got exception running Sqoop: > java.lang.RuntimeException: Could not load db driver class: > com.ingres.jdbc.IngresDriver java.lang.RuntimeException: Could not load db > driver class: com.ingres.jdbc.IngresDriver at > com.cloudera.sqoop.manager.SqlManager.makeConnection(SqlManager.java:635) > at > com.cloudera.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:53) > at com.cloudera.sqoop.manager.SqlManager.execute(SqlManager.java:524) at > com.cloudera.sqoop.manager.SqlManager.execute(SqlManager.java:547) at > com.cloudera.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:191) > at > com.cloudera.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:175) > at > com.cloudera.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:263) > at com.cloudera.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1226) > at com.cloudera.sqoop.orm.ClassWriter.generate(ClassWriter.java:1051) at > com.cloudera.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:84) at > com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:370) at > com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:456) at > com.cloudera.sqoop.Sqoop.run(Sqoop.java:146) at > org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65) at > com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:182) at > com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:221) at > com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:230) at > com.cloudera.sqoop.Sqoop.main(Sqoop.java:239) > > I'd really appreciate it if someone can help me out here. > > Thanks in advance! :) > > > -- > Amit S Namboothiry > Computer Science and Engineering(2009-2013) > Govt. Model Engineering College > Cochin-21 > +919447777039 > [email protected] > > > > -- > Amit S Namboothiry > Computer Science and Engineering(2009-2013) > Govt. Model Engineering College > Cochin-21 > +919447777039 > [email protected] > -- Proclivity(R) | We Value Your Customers(tm) This message is the property of Proclivity Systems, Inc. and is intended only for the use of the addressee(s), and may contain material that is confidential and privileged for the sole use of the intended recipient. If you are not the intended recipient, reliance or forwarding without express permission is strictly prohibited; please contact the sender and delete all copies.
