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:
%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