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