ποΈ 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.