Details for Programming Languages

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

Exasol currently supports the following programming languages for UDFs:

• Lua
• Java
• Python 3
• Python 2.7 (Deprecated)
• R

Python 2 has reached end of life and is no longer supported in Exasol. We recommend that you use Python 3 in all 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. For example:

%env MY_LIBRARY_PATH=/buckets/bfsdefault/my_libs/my_lib

UDF Instance Limiting

Exasol provides you with an option to control the number of UDF instances per UDF Call per Node to avoid query out-of-memory situations. It is applicable for Java, Python, and R languages. For more information, see UDF Instance Limiting