This chapter describes the built-in 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. UsingDocumentation Index
Fetch the complete documentation index at: https://dune-tables-docs.mintlify.app/llms.txt
Use this file to discover all available pages before exploring further.
SHOW FUNCTIONS in the query editor returns a list of all available functions, including custom functions, with all supported arguments and a short description.
DuneSQL Added Functions:
Trino Base Functions:
- Aggregate
- Array
- Binary
- Bitwise
- Comparison
- Conditional
- Conversion
- Date and time
- Decimal
- HyperLogLog
- json file currently not available
- Lambda
- Logical
- Map
- Math
- Quantile digest
- Regular expression
- Set Digest
- String
- System
- Teradata
- T-Digest
- URL
- UUID
- Window