Details for Programming Languages

This section describes how to use UDFs with different programming languages.

Exasol currently supports the following programming languages for UDFs:

Python 2 has reached end of life and is no longer supported in Exasol. We recommend that you use Python 3 in all Python UDFs.

Environment variables

You can set environment variables for the script execution using the syntax %env <variable>=<value>. One use case for this would be to set the path to libraries that are stored in BucketFS.

Example:
Copy
%env MY_LIBRARY_PATH=/buckets/bfsdefault/my_libs/my_lib

UDF instance limiting

To avoid query out-of-memory situations you can limit the number of UDF instances used for each UDF call per node. Instance limiting can be used in UDF scripts written in Java, Python, and R. To learn more, see UDF Instance Limiting