System functions
These functions return metadata type of information about the system being queried.
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---------------elasticsearchUSER()Input:none
Output: string
Description: Returns the username of the authenticated user executing the query. This function can returnnull in casesecurity is disabled.
SELECT USER(); USER---------------elastic