HP Vertica Cluster to HDFS platform Using SQOOP

Follow below steps to Achieve the importing from HP vertica cluster to HDFS.

Step 1:

Please download and add recent version of below jars to Sqoop library

vertica-jdbc-7.1.2-0.jar;

vertica-jdk5-6.1.3-0.jar

hadoop-vertica.jar

Step 2:

Please use below query to run  using sqoop.

>  sqoop import \

 --driver com.vertica.jdbc.Driver  \

--connect jdbc:vertica://<HOSTNAME>:5433/<DATABASE-NAME> \

 --username <UNAME> \

 -P \

 --table <TABLE-NAME> \

 --target-dir <TARGET-DIRECTORY-NAME>  \

--as-textfile  \

-m <No-Mappers>