Tag Archives: vertica

Tips: Vertica

Copy data from HDFS to Vertica COPY <Vertica database> Hdfs(url=’http://<NameNode&gt;:50070/webhdfs/v1/<path in hdfs>’, username='<hdfs user>’) DELIMITER ‘,’   stay tuned… Advertisements

Posted in Tips, vertica | Tagged , | Leave a comment

Tips: Sqoop

Override Cluster properties Eg:- disable compression for sqoop output when compression is turned on in the cluster sqoop import -Dmapred.job.queue.name=default \ -Dmapreduce.map.output.compress=false \ -Dmapreduce.output.fileoutputformat.compress=false \ –driver com.ibm.db2.jcc.DB2Driver –connect jdbc:db2://<host>/<db>\ –username <user>–password <pwd> \ –table <db2 table> –target-dir <hdfs path> \ … Continue reading

Posted in sqoop, Tips | Tagged , , , , , | Leave a comment