原英文版地址: https://www.elastic.co/guide/en/elasticsearch/reference/7.7/sql-functions-system.html, 原文档版权归 www.elastic.co 所有
本地英文版地址: ../en/sql-functions-system.html
重要: 此版本不会发布额外的bug修复或文档更新。最新信息请参考 当前版本文档。
Elasticsearch Guide [7.7] » SQL access » Functions and Operators » System Functions
« Conditional Functions And Expressions Reserved keywords »

System Functionsedit

These functions return metadata type of information about the system being queried.

DATABASEedit

Synopsis:

DATABASE()

Input: none

Output: string

Description: Returns the name of the database being queried. In the case of Elasticsearch SQL, this is the name of the Elasticsearch cluster. This function should always return a non-null value.

SELECT DATABASE();

   DATABASE
---------------
elasticsearch

USERedit

Synopsis:

USER()

Input: none

Output: string

Description: Returns the username of the authenticated user executing the query. This function can return null in case security is disabled.

SELECT USER();

     USER
---------------
elastic
« Conditional Functions And Expressions Reserved keywords »