Data Lake Analytics (DLA) provides a serverless Presto query engine. This query engine is developed based on Presto 0.227 and supports most functions defined in Presto 0.227. For more information.
In addition to the functions defined in Presto 0.227, DLA also supports the following functions:
- Aggregate functions: These functions are used to calculate a result for a group of data.
- Binary functions: These functions are used to return, encode, and decode binary data.
- Bitwise operation functions: These functions are used to perform bitwise operations.
- Casting functions: These functions are used to implicitly convert values of the numeric or character type to a specified type.
- Date and time functions: These functions are used for date and time.
- Funnel analysis functions: These functions are used to perform funnel analysis.
- Geospatial functions: These functions are used to query geometry data.
- JSON Functions: These functions are used to perform operations associated with JSON data.
- Mathematical functions: These functions are used to perform mathematical operations.
- Phone number functions: These functions are used to query information of phone numbers.
- Event time series analysis functions: These functions are used to obtain the time series of events based on the time that the events occurred and the timestamps of the events.
- SQL analysis functions: These functions are used to analyze SQL statements.
- String functions: These functions are used to perform operations on strings.
- Conditional expression functions: These functions are used for conditional expressions.
- Window functions: These functions are used to calculate a result based on row data from the query result in a window.