title: Vectorwise to Hive using Sqoop
body: <p>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.</p>
  
  <p>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</p>
  
  <p>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)</p>
  
  <p>I'd really appreciate it if someone can help me out here.</p>
  
  <p>Thanks in advance! :)</p>