title: Accessing Vertica Database through Oozie sqoop
body: <p>I have written an Oozie workflow to access an HP Vertica database through Sqoop. This is on a Cloudera VM. I am getting the following error in Yarn logs after running:</p>
  
  <pre><code>     RROR sqoop.Sqoop: Got exception running Sqoop:    java.lang.RuntimeException:        Could not load db driver class: dbDriver
       java.lang.RuntimeException: Could not load db driver class: dbDriver
       at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:848)
       at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52)
       at org.apache.sqoop.tool.EvalSqlTool.run(EvalSqlTool.java:64)
       at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
       at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
       at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
       at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
       at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)"
  
  This is a snippet from the jobprops file:
        "dbDriver=com.vertica.jdbc.Driver
       dbHost=host***.assist.*** 
       dbName=vertica247
       dbPassword=*****
       dbPort=5433
       dbSchema=simod_chat
       dbStagingSchema=simodstg_chat
       dbUser=vertica"
  </code></pre>
  
  <p>What should I specify for --connection-manager? When I run the same workflow outside the VM, it runs without the connection-manager argument?</p>