Extending Vertica
You can extend Vertica to perform new operations or handle new types of data. There are several types of extensions:
- External procedures let you execute external scripts or programs that are installed on a host in your database cluster.
- User-Defined SQL Functions let you store frequently-used SQL expressions. They can help you simplify and standardize your SQL scripts.
- User-Defined Extensions (UDxs) let you develop your own analytic or data-loading tools using the C++, Python, Java, and R programming languages. They are useful when the type of data processing you want to perform is difficult or slow using SQL.
The following sections explain how to use extensions that have already been written:
Developing User-Defined Extensions (UDxs) explains how to write new UDxs, including the following types: