Back to Elasticsearch

Reserved keywords [sql-syntax-reserved]

docs/reference/query-languages/sql/sql-syntax-reserved.md

9.4.02.6 KB
Original Source

Reserved keywords [sql-syntax-reserved]

Table with reserved keywords that need to be quoted. Also provide an example to make it more obvious.

The following table lists all of the keywords that are reserved in Elasticsearch SQL, along with their status in the SQL standard. These reserved keywords must be quoted (using double quotes) in order to be used as an identifier, for example:

sql
SELECT "AS" FROM index
KeywordSQL:2016SQL-92
ALLreservedreserved
ANDreservedreserved
ANYreservedreserved
ASreservedreserved
ASCreservedreserved
BETWEENreservedreserved
BYreservedreserved
CASTreservedreserved
CATALOGreservedreserved
CONVERTreservedreserved
CURRENT_DATEreservedreserved
CURRENT_TIMESTAMPreservedreserved
CURRENT_TIMEreservedreserved
DAYreservedreserved
DAYS
DESCreservedreserved
DESCRIBEreservedreserved
DISTINCTreservedreserved
ESCAPEreservedreserved
EXISTSreservedreserved
EXPLAINreservedreserved
EXTRACTreservedreserved
FALSEreservedreserved
FIRSTreservedreserved
FROMreservedreserved
FULLreservedreserved
GROUPreservedreserved
HAVINGreservedreserved
HOURreservedreserved
HOURS
INreservedreserved
INNERreservedreserved
INTERVALreservedreserved
ISreservedreserved
JOINreservedreserved
LEFTreservedreserved
LIKEreservedreserved
LIMITreservedreserved
MATCHreservedreserved
MINUTEreservedreserved
MINUTES
MONTHreservedreserved
NATURALreservedreserved
NOTreservedreserved
NULLreservedreserved
NULLS
ONreservedreserved
ORreservedreserved
ORDERreservedreserved
OUTERreservedreserved
RIGHTreservedreserved
RLIKE
QUERY
SECONDreservedreserved
SECONDS
SELECTreservedreserved
SESSIONreserved
TABLEreservedreserved
TABLES
THENreservedreserved
TOreservedreserved
TOPreservedreserved
TRUEreservedreserved
TYPE
USINGreservedreserved
WHENreservedreserved
WHEREreservedreserved
WITHreservedreserved
YEARreservedreserved
YEARS