Skip to main content
Version: latest

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;