Functions
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. StarRocks also provides Hive Bitmap UDFs. You can generate Bitmap data in Hive and then load Bitmap into StarRocks. You can also export the Bitmap data generated in StarRocks to Hive for other systems to use.
Java UDF
From v2.2.0 onwards, you can compile user-defined functions (UDFs) to suit your specific business needs by using the Java programming language.
Lambda expression
Lambda expressions are anonymous functions that can be passed as parameters into higher-order SQL functions.
Window functions
The window function is a special class of built-in functions.
CAST
Converts an input into the specified type.
Hive Bitmap UDF
Hive Bitmap UDF provides UDFs that can be directly used in Hive.
Python UDF
Since v3.4.0, StarRocks supports creating Python UDFs.
SQL UDF
Since version 4.1, StarRocks supports creating SQL user-define-functions(UDFs), allowing users to create functions using SQL expressions.
Aggregate
43 items
Array
37 items
Binary
2 items
Bit
7 items
Bitmap
32 items
Condition
5 items
Cryptographic
11 items
Date and time
86 items
Dictionary
2 items
Hash
3 items
JSON
4 items
Pattern matching
6 items
Map
12 items
Math
45 items
Percentile
7 items
Scalar
3 items
Spatial
10 items
String
58 items
Struct
2 items
Table
2 items
Utility
21 items
Variant functions
3 items
meta-functions
14 items