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. Lambda expressions allow you to develop code that is more concise, elegant, and extensible.
Window functions
Background
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.
Python UDF
This topic describes how to develop User Defined Functions (UDF) using Python.
Aggregate
38 items
Array
35 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
55 items
Struct
2 items
Table
2 items
Utility
16 items