NOTE: You are looking at documentation for an older release. 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