Functions and Operators

This chapter describes the SQL functions and operators supported by Presto. They allow you to implement complex functionality and behavior of the SQL executed by Presto 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.

• Logical
• Comparison
• Conditional
• Lambda
• Conversion
• Math
• Bitwise
• Decimal
• String
• Regular Expression
• Binary
• JSON
• Date and Time
• Aggregate
• Window
• Array
• Map
• URL
• Geospatial
• HyperLogLog
• Quantile Digest
• T-Digest
• UUID
• Color
• Session
• Teradata
• Machine Learning
• List of Functions and Operators