Skip to main content
Version: 2.4.x

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;