title: Importing vertica data to sqoop
body: <p>I am injecting vertica data to sqoop1 on a mapr cluster. I use the following query : </p>
  
  <pre><code> sqoop import -m 1 --driver com.vertica.jdbc.Driver --connect "jdbc:vertica://*******:5433/db_name" --password "password" --username "username" --table "schemaName.tableName" --columns "id" --target-dir "/t" --verbose
  </code></pre>
  
  <p><strong>This query gives me an error that</strong>   </p>
  
  <pre><code>Caused by: com.vertica.util.ServerException: [Vertica][VJDBC](4856) ERROR: Syntax error at or near "."
  </code></pre>
  
  <p>I read  <a href="https://groups.google.com/a/cloudera.org/forum/#!msg/cdh-user/xIBwvc_eOp0/TvhANQfvcv4J" rel="nofollow">https://groups.google.com/a/cloudera.org/forum/#!msg/cdh-user/xIBwvc_eOp0/TvhANQfvcv4J</a> for getting more information regarding this, but wasnt quite helpful as they gave results on Sqoop2.</p>
  
  <p>When I run this query : </p>
  
  <pre><code>sqoop import -m 1 --driver com.vertica.jdbc.Driver --connect "jdbc:vertica://*******:5433/db_name" --password "password" --username "username" --table "tableName" --columns "id" --target-dir "/t" --verbose
  </code></pre>
  
  <p><strong>It gives an error: Relation "tableName" doesnt exist.</strong></p>
  
  <p>I have added the required vertica-jdk jars in sqoop library too.</p>
  
  <p>Any help regarding how to mention schema name in sqoop for vertica?</p>