Setting Up a Development Environment

Before you start developing your UDx, you need to configure your development environment. You can choose to develop your UDx on a node in a development Vertica database (not in a production environment) or on another machine.

To test, you need access to a (non-production) Vertica database. You can install a single-node Vertica database on your development machine for easier development.

You should develop your UDx code on the same Linux platform that you use on your Vertica database cluster. This will ensure that your UDx library is compatible with the Vertica version deployed on your cluster.

The following sections describe language-specific requirements.

C++ Requirements

At a minimum, you need to install the following on your development machine:

Note: The Vertica binaries are compiled using the default version of g++ installed on the supported Linux platforms. While other versions of g++ (or even entirely different compilers) may produce compatible libraries, only the platform’s default g++ version is supported for compiling UDxs.

While not required, the following additional software packages can ease development:

If you want to use any third-party libraries (for example, statistical analysis libraries), you need to install them on your development machine. If you do not statically link these libraries into your UDx library, you also have to install them on every node in the cluster. See Compiling Your C++ Library for details.

Java Requirements

At a minimum, you need to install the following on your development machine:

While not required, make or some other build-management tool can ease development.

Python Requirements

Vertica does not require any additional files or packages. You can develop your Python UDx on any system with a text editor.

Important: When you begin UDx development, make sure that your code runs using Python 3.5.1. because you cannot change the version used by the Vertica Python interpreter.

When Vertica calls your UDx, it starts a side process that manages the interaction between the server and the Python interpreter.

R Requirements

Vertica does not require any additional files or packages. You can develop your R UDx on any system with a text editor.