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
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.
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 ?
Comments