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 .

Functions by name

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

:::{toctree} :maxdepth: 1

functions/list functions/list-by-topic :::

Functions per topic

{toctree}

:maxdepth: 1

Aggregate           <functions/aggregate>
AI                  <functions/ai>
Array               <functions/array>
Binary              <functions/binary>
Bitwise             <functions/bitwise>
Color               <functions/color>
Comparison          <functions/comparison>
Conditional         <functions/conditional>
Conversion          <functions/conversion>
DataSketches        <functions/datasketches>
Date and time       <functions/datetime>
Decimal             <functions/decimal>
Geospatial          <functions/geospatial>
HyperLogLog         <functions/hyperloglog>
IP Address          <functions/ipaddress>
JSON                <functions/json>
Lambda              <functions/lambda>
Logical             <functions/logical>
Machine learning    <functions/ml>
Map                 <functions/map>
Math                <functions/math>
Quantile digest     <functions/qdigest>
Regular expression  <functions/regexp>
Session             <functions/session>
Set Digest          <functions/setdigest>
String              <functions/string>
System              <functions/system>
Table               <functions/table>
Teradata            <functions/teradata>
T-Digest            <functions/tdigest>
URL                 <functions/url>
UUID                <functions/uuid>
Window              <functions/window>