Let's discuss those new features that were mentioned in Chapter 1, Overview of Elasticsearch 7, as follows. We will use elasticsearch-sql-cli to play around the topics:
- DATABASE() and USER() system functions: The DATABASE() function returns the current working database instance, and the user() function returns the current user. As shown in the following screenshot, the current working database is docker-cluster, while there is no current user since we have not yet set up the user authentication:
- INTERVAL keyword: This is a keyword for converting the subsequent literal into a date-time interval. Let's see how it is used. The ...