BAR
Use the BAR utility function in PlaidCloud Lakehouse. Returns a visual bar string representation of a value within a range. Useful for text-based.
Utility Functions
This section provides reference information for the utility functions in PlaidCloud Lakehouse.
CATALOG
Learn how to use the CATALOG utility function in PlaidCloud Lakehouse. Returns the name of the current catalog - see syntax, examples, and output.
COLUMN_COMPRESSED_SIZE
Learn how to use the COLUMN_COMPRESSED_SIZE utility function in PlaidCloud Lakehouse. Returns the compressed size in bytes of a column value.
COLUMN_SIZE
Learn how to use the COLUMN_SIZE utility function in PlaidCloud Lakehouse. Returns the size in bytes of a column value in its serialized form.
CURRENT_ROLE
Learn how to use the CURRENT_ROLE utility function in PlaidCloud Lakehouse. Returns the current active role - see syntax, examples, and output.
CURRENT_VERSION
Learn how to use the CURRENT_VERSION utility function in PlaidCloud Lakehouse. Returns the current version of StarRocks - see syntax, examples, and output.
CURRENT_WAREHOUSE
Learn how to use the CURRENT_WAREHOUSE utility function in PlaidCloud Lakehouse. Returns the name of the current warehouse - with syntax and examples.
DATABASE
Learn how to use the DATABASE utility function in PlaidCloud Lakehouse. Returns the name of the current database - see syntax, examples, and output.
ENCODE_SORT_KEY
Use the ENCODE_SORT_KEY utility function in PlaidCloud Lakehouse. Encodes values into a binary sort key that preserves the sort order. Useful for compound.
EQUIWIDTH_BUCKET
Use the EQUIWIDTH_BUCKET utility function in PlaidCloud Lakehouse. Returns the bucket number for a value in an equi-width histogram. Divides the range [min,.
GET_QUERY_PROFILE
Use the GET_QUERY_PROFILE utility function in PlaidCloud Lakehouse. Returns the query profile for a specified query ID. Useful for performance analysis and.
HOST_NAME
Learn how to use the HOST_NAME utility function in PlaidCloud Lakehouse. Returns the host name of the current backend node - with syntax and examples.
IS_ROLE_IN_SESSION
Learn how to use the IS_ROLE_IN_SESSION utility function in PlaidCloud Lakehouse. Checks whether a specified role is active in the current session.
ISNOTNULL
Learn how to use the ISNOTNULL utility function in PlaidCloud Lakehouse. Checks whether a value is not NULL. Returns 1 if not NULL, 0 otherwise.
ISNULL
Learn how to use the ISNULL utility function in PlaidCloud Lakehouse. Checks whether a value is NULL. Returns 1 if NULL, 0 otherwise - with syntax and examples.
LAST_QUERY_ID
Learn how to use the LAST_QUERY_ID utility function in PlaidCloud Lakehouse. Returns the ID of the most recently executed query - with syntax and examples.
SLEEP
Learn how to use the SLEEP utility function in PlaidCloud Lakehouse. Pauses execution for a specified number of seconds. Returns 0 on success.
UUID
Learn how to use the UUID utility function in PlaidCloud Lakehouse. Returns a random UUID string - see syntax, examples, and output.
UUID_NUMERIC
Learn how to use the UUID_NUMERIC utility function in PlaidCloud Lakehouse. Returns a random UUID as a 128-bit LARGEINT value - with syntax and examples.
UUID_V7
Learn how to use the UUID_V7 utility function in PlaidCloud Lakehouse. Returns a time-ordered UUID v7 string. UUID v7 values are sortable by creation time.
UUID_V7_NUMERIC
Use the UUID_V7_NUMERIC utility function in PlaidCloud Lakehouse. Returns a time-ordered UUID v7 as a 128-bit LARGEINT value. UUID v7 values are sortable by.
VERSION
Learn how to use the VERSION utility function in PlaidCloud Lakehouse. Returns the MySQL protocol version of StarRocks - see syntax, examples, and output.