Extending Vertica

You can extend Vertica to perform new operations or handle new types of data.

You can extend Vertica to perform new operations or handle new types of data. There are several types of extensions:

  • External procedures: external scripts or programs that are installed on a host in your database cluster.

  • User-defined SQL functions: Frequently-used SQL expressions, which help you simplify and standardize your SQL scripts.

  • Stored Procedures: SQL procedures that are stored in the database (as opposed to external procedures). Stored procedures can communicate and interact with your database directly to perform maintenance, execute queries, and update tables.

  • User-defined extensions (UDxs): functions or data-load steps written in 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. User-defined extensions explains how to use them and Developing user-defined extensions (UDxs) explains how to create them.

In this section