bar
Draw a bar graph like histogram to inspect the data distribution.
catalog
Returns the name of the current catalog. The catalog can be a StarRocks internal catalog or an external catalog that is mapped to an external data source. For more information about catalogs, see Catalog overview.
current_role
Queries roles that are activated for the current user.
current_version
Returns the current version of StarRocks. Two syntaxes are provided for compatibility with different clients.
database
Returns the name of the current database. If no database is selected, an empty value is returned.
equiwidth_bucket
Calculate the equi-width histogram bucket.
get_query_profile
Obtains the profile of a query by using its queryid. This function returns empty if the queryid does not exist or is incorrect.
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. 1 is returned if the sleep is completed without interruption. Otherwise, 0 is returned.
uuid
Returns a random UUID of the VARCHAR type. Two calls to this function can generate two different numbers. The UUID is 36 characters in length. It contains 5 hexadecimal numbers which are connected with four hyphens in the aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee format.
uuid_numeric
Returns a random UUID of the LARGEINT type. This function has an execution performance 2 orders of magnitude better than the uuid function.
version
Returns the current version of the MySQL database.