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.
ποΈ Window functions
- Window functions
ποΈ CAST
Description
ποΈ 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
33 items
ποΈ Array
34 items
ποΈ Binary
2 items
ποΈ Bit
7 items
ποΈ Bitmap
31 items
ποΈ Condition
5 items
ποΈ Cryptographic
11 items
ποΈ Date and time
80 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
51 items
ποΈ Struct
2 items
ποΈ Table
2 items
ποΈ Utility
14 items