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 the execution of an operation for a specified period of time (in seconds) and returns a BOOLEAN value to indicate whether the sleep is 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.