IMPORTANT: No additional bug fixes or documentation updates
will be released for this version. For the latest information, see the
current release documentation.
These functions return metadata type of information about the system being queried.
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
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