Other Functions
Other functional functions include some general functions that do not belong to the above categories.
arrow_cast
The purpose of arrow_cast
is to convert data from one type to another type.
arrow_typeof
Return the underlying Arrow data type of the expression.
current_user
Returns the username of the current database session, typically used to determine the identity of the current user performing operations.
SELECT current_user();
current_tenant
Returns the tenant name of the current database session.
SELECT current_tenant();
current_role
The role of the current user in the current tenant (NULL will be returned if it does not exist)
SELECT current_role();
current_database
Return the name of the current database operation.
SELECT current_database();
@@cluster_name
Cluster name.
SELECT @@cluster_name;
@@server_version
Server version.
SELECT @@server_version;
@@deployment_mode
Deployment mode.
SELECT @@deployment_mode;
@@node_id
Current node ID.
SELECT @@node_id;