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.
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.