Functions and operators#

This section describes the built-in SQL functions and operators supported by Trino. They allow you to implement complex capabilities and behavior of the queries executed by Trino operating on the underlying data sources.

Refer to the following sections for further details:

In addition, Trino supports implementation of custom functions or custom table functions provided by a plugin, and creation of user-defined functions as SQL routines.

Functions by name#

If you are looking for a specific function or operator by name use SHOW FUNCTIONS, or refer the to the following resources:

Functions per topic#