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