IMPORTANT: No additional bug fixes or documentation updates
will be released for this version. For the latest information, see the
current release documentation.
System Functions
editSystem Functions
editThese functions return metadata type of information about the system being queried.
DATABASE
editSynopsis:
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
editSynopsis:
USER()
Input: none
Output: string
Description:Returns the username of the authenticated user executing the query. This function can
return null in case security features are disabled.
SELECT USER();
USER
---------------
elastic