Skip to main content
Version: Latest-3.1

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, MAP, and STRUCT 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​

Binary functions​

Bit functions​

Bitmap functions​

Conditional functions​

Cryptographic functions​

Date functions​

Geographic functions​

Hash functions​

JSON functions​

String functions​

Map functions​

Math functions​

Pattern matching functions​

Percentile functions​

Scalar functions​

Struct functions​

Table functions​

Utility functions​