SQL analysis provides built-in functions that cover most data processing scenarios. The following table lists the supported function types.
Supported function types
SQL analysis provides the following built-in function types.
|
Function type |
Description |
|
Operates on DATE, DATETIME, and TIMESTAMP types. Supports date arithmetic, difference calculation, field extraction, current time retrieval, and format conversion. |
|
|
Operates on BIGINT, DOUBLE, DECIMAL, and FLOAT types. Supports base conversion, arithmetic, rounding, and random number generation. |
|
|
Performs calculations over a defined window, including sums, min/max, averages, medians, sorting, offsets, and sampling. |
|
|
Aggregates multiple records into a single value. Supports sums, averages, min/max, parameter aggregation, and string concatenation. |
|
|
Operates on STRING data. Supports truncation, replacement, search, case conversion, and format conversion. |
|
|
Operates on MAP and ARRAY types for structured data processing. |
|
|
Additional functions for various business scenarios. |