7. 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.
Ensure to also consult our reference to the supported SQL data types and other general characteristics and a full SQL statement and syntax reference are available.
If you are looking for more information about a specific function or operator, see our complete list.
- 7.1. Logical Operators
- 7.2. Comparison Functions and Operators
- 7.3. Conditional Expressions
- 7.4. Lambda Expressions
- 7.5. Conversion Functions
- 7.6. Mathematical Functions and Operators
- 7.7. Bitwise Functions
- 7.8. Decimal Functions and Operators
- 7.9. String Functions and Operators
- 7.10. Regular Expression Functions
- 7.11. Binary Functions and Operators
- 7.12. JSON Functions and Operators
- 7.13. Date and Time Functions and Operators
- 7.14. Aggregate Functions
- 7.15. Window Functions
- 7.16. Array Functions and Operators
- 7.17. Map Functions and Operators
- 7.18. URL Functions
- 7.19. Geospatial Functions
- 7.20. HyperLogLog Functions
- 7.21. Quantile Digest Functions
- 7.22. UUID Functions
- 7.23. Color Functions
- 7.24. Session Information
- 7.25. Teradata Functions
- 7.26. Machine Learning Functions
- 7.27. List of Functions and Operators