CURRENT_SESSION

Returns information about the current active session. 返回当前活跃会话的信息。

图例

• ✅ = 字段存在于该版本
• ❌ = 字段不存在于该版本
• 备注列标注首次出现或类型变更的版本

字段名	Data Type	11.0.x	11.1.x	12.0.x	23.3.x	23.4.x	24.1.x	24.2.x	24.3.x	24.4.x	25.1.x	25.2.x	25.3.x	25.4.x	26.1.x	26.2.x	备注
CLIENT_HOSTNAME	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
CLIENT_LABEL	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
CLIENT_OS	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
CLIENT_OS_HOSTNAME	VARCHAR	✅	❌	❌	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
CLIENT_OS_USER_NAME	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
CLIENT_PID	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
CLIENT_TYPE	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
CLIENT_VERSION	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
CURRENT_STATEMENT	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
EFFECTIVE_PROTOCOL	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
EXECUTION_ENGINE_PROFILING_CONFIGURATION	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
LAST_STATEMENT	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
LAST_STATEMENT_DURATION_US	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
LOGIN_TIMESTAMP	TIMESTAMP	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
NODE_NAME	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
QUERY_PROFILING_CONFIGURATION	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
REQUESTED_PROTOCOL	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
SESSION_ID	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
SESSION_PROFILING_CONFIGURATION	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
STATEMENT_ID	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
STATEMENT_START	TIMESTAMP	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
TRANSACTION_DESCRIPTION	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
TRANSACTION_ID	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
TRANSACTION_START	TIMESTAMP	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
TYPE	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
USER_NAME	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅