Utility
bar
Draw a bar graph like histogram to inspect the data distribution.
catalog
Returns the name of the current catalog.
column_size & column_compressed_size
These functions return the size information of table columns for storage analysis and optimization.
current_role
Queries roles that are activated for the current user.
current_version
Returns the current version of StarRocks.
CURRENT_WAREHOUSE
Returns the effective warehouse name for the current session, reflecting the warehouse set via SET WAREHOUSE or the default warehouse.
database
Returns the name of the current database.
encode_sort_key
Creates an order-preserving composite binary key from multiple heterogeneous input columns.
equiwidth_bucket
Calculate the equi-width histogram bucket.
get_query_profile
Obtains the profile of a query by using its query_id.
host_name
Obtains the hostname of the node on which the computation is performed.
is_role_in_session
Verifies whether a role (or a nested role) is active in the current session.
isnotnull
Checks whether the value is not NULL, returns 1 if it is not NULL, and returns 0 if it is NULL.
isnull
Checks whether the value is NULL, returns 1 if it is NULL, and returns 0 if it is not NULL.
last_query_id
Obtains the ID of the most recently executed query in the current session.
materialize
Returns the input value unchanged but acts as an optimization barrier for the FE (Frontend) optimizer.
sleep
Delays query execution for a specified number of seconds and returns whether the sleep completed without interruption.
uuid
Returns a random UUID of the VARCHAR type.
uuid_numeric
Returns a random UUID of the LARGEINT type.
uuid_v7_numeric
Returns a time-ordered UUID v7 of the LARGEINT type.
uuid_v7
Returns a time-ordered UUID v7 of the VARCHAR type.
version
Returns the current version of the MySQL database.