Vertica connectors and plugins Questions?

George_Carlisle

Which of the technical manuals talks indepth about the Vertica connectors and plugins? I'm loading Vertica into a Suse VM this weekend.

[Deleted User]

Hi George, Could you be a little more specific? Are you asking as a user of these plugins or as a developer? What are you trying to do?; there are several ways to connect to Vertica, to connect Vertica to other systems, etc. If you're a developer, I would recommend the SDK API guide; or just start looking around in /opt/vertica/sdk/examples/ in your VM. If you're a user, what are you trying to do? We have a number of connectors and plugins on the downloads page. These are self-documenting; download the one you want and open it up to view its documentation. The command-line "vsql" program does a lot, in terms of scriptable loading of data from different systems. Take a look at the "COPY" and "COPY LOCAL" pages in the main documentation (<>) for loading data, and vsql's command-line options for export (for example, "vsql -tAc 'select * from t;'"). To pull in data from another Vertica database, look at the COPY FROM VERTICA page in the main docs. There are several useful-but-unsupported connectors and plugins installed by our RPM to /opt/vertica/sdk/examples/ ; also several on https://github.com/vertica/ . These are all available only as source code currently; you'll have to compile them by running "make" (on a system with a C++ compiler installed). There are also a wide variety of third-party external tools that people use to connect to Vertica and to connect Vertica to other databases. We are a SQL database, with standard JDBC and ODBC connectors; many existing tools work with us, and more and more are specifically tuned for us. If you post a more-specific question, you'll likely get a more-specific response on this front. Adam

David_Chen

How do you use the HDFS Connector? The examples here http://www.vertica.com/2012/07/05/teaching-the-elephant-new-tricks/ don't work. Also what is the difference between the Hadoop Connector and the HDFS Connector?

[Deleted User]

Could you clarify what you mean by "don't work"? What issues are you seeing? The Hadoop Connector lets you interact with Hadoop jobs. The HDFS connector lets you load files out of HDFS.

venkat_2

HDFS connector doesn't work for me too.. I verified that WEB-HDFS is responding well, but native COPY is nto working from vertica. Please look here : https://community.vertica.com/vertica/topics/problem_with_hdfs_vertica_connector

David_Chen

Well, to clarify, the HDFS connector DOES work, but it opens up 100 simultaneous connections to Vertica to do so.  Is there a way to limit the number of simultaneous connections to Vertica ?