IMPORTANT: No additional bug fixes or documentation updates will be released for this version. For the latest information, see the current release documentation.
« Conditional Functions Reserved keywords »
Elastic Docs ›Elasticsearch Guide [6.6] ›SQL Access ›Functions and Operators

System Functions

edit

System Functions

edit

This functionality is in beta and is subject to change. The design and code is less mature than official GA features and is being provided as-is with no warranties. Beta features are not subject to the support SLA of official GA features.

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

DATABASE

edit

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

USER

edit

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 Reserved keywords »