Showing posts with label Sqoop. Show all posts
Showing posts with label Sqoop. Show all posts

Thursday, May 26, 2016

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>