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 UDFs
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. Lambda expressions allow you to develop code that is more concise, elegant, and extensible.
ποΈ Python UDF
Since version 3.4.0, StarRocks supports writing User Defined Function (UDF) in Python.
ποΈ Window functions
- Window functions
ποΈ CAST
Converts an input into the specified type. For example, cast (input as BIGINT) converts the input into a BIGINT value.
ποΈ Hive Bitmap UDF
Hive Bitmap UDF provides UDFs that can be directly used in Hive. They can be used to generate Bitmap data and perform Bitmap-related calculations.
ποΈ Aggregate
36 items
ποΈ Array
34 items
ποΈ Binary
2 items
ποΈ Bit
7 items
ποΈ Bitmap
31 items
ποΈ Condition
5 items
ποΈ Cryptographic
11 items
ποΈ Date and time
81 items
ποΈ Dictionary
2 items
ποΈ Hash
3 items
ποΈ JSON
4 items
ποΈ Pattern matching
5 items
ποΈ Map
12 items
ποΈ Math
45 items
ποΈ Percentile
7 items
ποΈ Scalar
3 items
ποΈ Spatial
10 items
ποΈ String
52 items
ποΈ Struct
2 items
ποΈ Table
2 items
ποΈ Utility
16 items