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:

• SQL data types and other general aspects

• SQL statement and syntax reference

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:

• List of functions and operators
• List of functions by topic

Functions per topic

• Aggregate
• Array
• Binary
• Bitwise
• Color
• Comparison
• Conditional
• Conversion
• Date and time
• Decimal
• Geospatial
• HyperLogLog
• IP Address
• JSON
• Lambda
• Logical
• Machine learning
• Map
• Math
• Quantile digest
• Regular expression
• Session
• Set Digest
• String
• System
• Table
• Teradata
• T-Digest
• URL
• UUID
• Window