Advanced Elasticsearch 7.0

Reserved keywords

Reserved keywords are part of the language syntax that the server uses to parse and analyze the statements. The following list shows the Elasticsearch SQL reserved keywords. If you use a reserved keyword as an identifier in the SQL statement, you must use double quotes to escape it:

ALL, AND, ANY, AS, ASC, BETWEEN, BY, CAST, CATALOG, CONVERT, CURRENT_DATE, CURRENT_TIMESTAMP, DAY, DAYS, DESC, DESCRIBE, DISTINCT, ESCAPE, EXISTS, EXPLAIN, EXTRACT, FALSE, FIRST, FROM, FULL, GROUP, HAVING, HOUR, HOURS, IN, INNER, INTERVAL, IS, JOIN, LEFT, LIKE, LIMIT, MATCH, MINUTE, MINUTES, MONTH, NATURAL, NOT, NULL, NULLS, ON, OR, ORDER, OUTER, RIGHT, RLIKE, QUERY, SECOND, SECONDS, SELECT, SESSION, TABLE, TABLES, THEN, TO, TRUE, TYPE, USING, ...