Functions and operators

This chapter describes the SQL functions and operators supported by Trino. They allow you to implement complex functionality and behavior of the SQL executed by Trino operating on the underlying data sources.

If you are looking for a specific function or operator, see the full list.

Also see the SQL data types and the SQL statement and syntax reference.

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