Skip to main content
Version: 2.5

Function list

StarRocks offers a rich set of functions to facilitate data queries and analysis. In addition to commonly used functions, StarRocks supports semi-structured functions such as ARRAY, JSON, and MAP functions. It also supports higher-order Lambda functions. If these functions cannot meet your business requirements, you can use Java UDF to compile functions.

You can find a function based on the following categories:

Aggregate functions

Array functions

Bit functions

Bitmap functions

Conditional functions

Cryptographic functions

Date and time functions

Geographic functions

Hash functions

JSON functions

String functions

Map functions

Math functions

Pattern matching functions

Percentile functions

Scalar functions

Table functions

Utility functions