Skip to main content
Version: 3.1.0 (Latest)

Keywords

This topic covers keywords in Apache Ignite 3.

Non-reserved keywords can be used as identifiers (names for tables, columns, etc.) without requiring quotation marks or special escaping. These keywords have meaning in SQL contexts but do not conflict with basic SQL grammar.

Reserved keywords must be wrapped in double quotes to be used as identifiers, for example, table names or column names. If a reserved word is used as an identifier without being quoted, a syntax error will happen.

-- Valid keyword usage.
SELECT 1 AS "ABS";

-- The query below would cause an error.
-- SELECT 1 AS ABS;

The following list shows the keywords in Apache Ignite 3.

KeywordApache Ignite 3SQL 2016
A
ABSReservedReserved
ABSENTReserved
ABSOLUTE
ACTION
ADA
ADD
ADMIN
AFTER
ALGORITHM
ALLReservedReserved
ALLOCATEReserved
ALLOW
ALTERReservedReserved
ALWAYS
ANDReservedReserved
ANYReservedReserved
APPLY
AREReserved
ARRAYReservedReserved
ARRAY_AGGReserved
ARRAY_CONCAT_AGG
ARRAY_MAX_CARDINALITYReservedReserved
ASReservedReserved
ASCReserved
ASENSITIVEReserved
ASOFReserved
ASSERTION
ASSIGNMENT
ASYMMETRICReservedReserved
ATReserved
ATOMICReserved
ATTRIBUTE
ATTRIBUTES
AUTHORIZATIONReserved
AUTO
AVGReservedReserved
BEFORE
BEGINReserved
BEGIN_FRAMEReserved
BEGIN_PARTITIONReserved
BERNOULLI
BETWEENReservedReserved
BIGINTReserved
BINARYReserved
BIT
BLOBReserved
BOOLEANReserved
BOTHReservedReserved
BREADTH
BYReservedReserved
C
CACHEReserved
CALLReservedReserved
CALLEDReserved
CARDINALITYReservedReserved
CASCADEReserved
CASCADEDReserved
CASEReservedReserved
CASTReservedReserved
CATALOG
CATALOG_NAME
CEIL
CEILINGReservedReserved
CENTURY
CHAIN
CHARReservedReserved
CHARACTERReservedReserved
CHARACTERISTICS
CHARACTERS
CHARACTER_LENGTHReservedReserved
CHARACTER_SET_CATALOG
CHARACTER_SET_NAME
CHARACTER_SET_SCHEMA
CHAR_LENGTHReservedReserved
CHECKReserved
CLASSIFIERReserved
CLASS_ORIGIN
CLOBReserved
CLOSEReserved
COALESCEReservedReserved
COBOL
COLLATEReserved
COLLATION
COLLATION_CATALOG
COLLATION_NAME
COLLATION_SCHEMA
COLLECTReservedReserved
COLOCATE
COLUMNReservedReserved
COLUMN_NAME
COMMAND_FUNCTION
COMMAND_FUNCTION_CODE
COMMITReserved
COMMITTED
COMPUTE
CONDITIONReserved
CONDITIONALReserved
CONDITION_NUMBER
CONNECTReserved
CONNECTION
CONNECTION_NAME
CONSISTENCY
CONSTRAINTReservedReserved
CONSTRAINTS
CONSTRAINT_CATALOG
CONSTRAINT_NAME
CONSTRAINT_SCHEMA
CONSTRUCTOR
CONTAINSReserved
CONTAINS_SUBSTR
CONTINUE
CONVERTReservedReserved
CORRReserved
CORRESPONDINGReserved
COUNTReservedReserved
COVAR_POPReservedReserved
COVAR_SAMPReservedReserved
CREATEReservedReserved
CROSSReservedReserved
CUBEReservedReserved
CUME_DISTReservedReserved
CURRENTReservedReserved
CURRENT_CATALOGReservedReserved
CURRENT_DATEReservedReserved
CURRENT_DEFAULT_TRANSFORM_GROUPReservedReserved
CURRENT_PATHReservedReserved
CURRENT_ROLEReservedReserved
CURRENT_ROWReservedReserved
CURRENT_SCHEMAReservedReserved
CURRENT_TIMEReservedReserved
CURRENT_TIMESTAMPReservedReserved
CURRENT_TRANSFORM_GROUP_FOR_TYPEReservedReserved
CURRENT_USERReservedReserved
CURSORReserved
CURSOR_NAME
CYCLEReserved
DATA
DATABASE
DATALINKReserved
DATEReservedReserved
DATETIMEReserved
DATETIME_DIFF
DATETIME_INTERVAL_CODE
DATETIME_INTERVAL_PRECISION
DATETIME_TRUNC
DATE_DIFF
DATE_TRUNC
DAYReserved
DAYOFWEEK
DAYOFYEAR
DAYS
DEALLOCATEReserved
DECReserved
DECADE
DECFLOATReserved
DECIMALReservedReserved
DECLAREReserved
DEFAULTReservedReserved
DEFAULTS
DEFERRABLE
DEFERRED
DEFINEReserved
DEFINED
DEFINER
DEGREE
DELETEReservedReserved
DENSE_RANKReservedReserved
DEPTH
DEREFReserved
DERIVED
DESC
DESCRIBEReservedReserved
DESCRIPTION
DESCRIPTOR
DETERMINISTIC
DIAGNOSTICS
DISALLOW
DISCONNECTReserved
DISPATCH
DISTINCTReservedReserved
DISTRIBUTION
DLNEWCOPYReserved
DLPREVIOUSCOPYReserved
DLURLCOMPLETEReserved
DLURLCOMPLETEONLYReserved
DLURLCOMPLETEWRITEReserved
DLURLPATHReserved
DLURLPATHONLYReserved
DLURLPATHWRITEReserved
DLURLSCHEMEReserved
DLURLSERVERReserved
DLVALUEReserved
DOMAIN
DOT
DOUBLEReserved
DOW
DOWN
DOY
DROPReservedReserved
DYNAMICReserved
DYNAMIC_FUNCTION
DYNAMIC_FUNCTION_CODE
EACHReserved
ELEMENTReservedReserved
ELSEReservedReserved
EMPTYReserved
ENCODING
ENDReserved
END-EXECReserved
END_FRAMEReserved
END_PARTITIONReserved
ENGINE
EPOCH
EQUALSReserved
ERROR
ESCAPEReserved
EVERYReservedReserved
EXCEPTReservedReserved
EXCEPTION
EXCLUDE
EXCLUDING
EXECReserved
EXECUTEReserved
EXISTSReservedReserved
EXPReservedReserved
EXPLAINReserved
EXTENDReserved
EXTERNALReserved
EXTRACTReservedReserved
FALSEReservedReserved
FETCHReservedReserved
FILTERReservedReserved
FINAL
FIRST
FIRST_VALUEReservedReserved
FLOATReserved
FLOORReservedReserved
FOLLOWING
FORReservedReserved
FOREIGNReserved
FORMAT
FORTRAN
FOUND
FRAC_SECOND
FRAME_ROWReserved
FREEReserved
FRIDAYReserved
FROMReservedReserved
FULLReservedReserved
FUNCTIONReserved
FUSIONReservedReserved
G
GENERAL
GENERATED
GEOMETRY
GETReserved
GLOBALReserved
GO
GOTO
GRANTReserved
GRANTED
GROUPReservedReserved
GROUPINGReservedReserved
GROUPSReserved
GROUP_CONCAT
HASH
HAVINGReservedReserved
HIERARCHY
HOLDReserved
HOP
HOURReservedReserved
HOURS
IDENTIFIEDReserved
IDENTITYReserved
IFReserved
IGNORE
ILIKE
IMMEDIATE
IMMEDIATELY
IMPLEMENTATION
IMPORTReserved
INReservedReserved
INCLUDE
INCLUDING
INCREMENT
INDEXReserved
INDICATORReserved
INITIALReserved
INITIALLYReserved
INNERReservedReserved
INOUTReserved
INPUT
INSENSITIVEReserved
INSERTReservedReserved
INSTANCE
INSTANTIABLE
INTReserved
INTEGERReserved
INTERSECTReservedReserved
INTERSECTIONReservedReserved
INTERVALReservedReserved
INTOReservedReserved
INVOKER
ISReservedReserved
ISODOW
ISOLATION
ISOYEAR
JAVA
JOINReservedReserved
JSONReserved
JSON_ARRAYReserved
JSON_ARRAYAGGReserved
JSON_EXISTSReserved
JSON_OBJECTReserved
JSON_OBJECTAGGReserved
JSON_QUERYReserved
JSON_SCOPEReserved
JSON_TABLEReserved
JSON_TABLE_PRIMITIVEReserved
JSON_VALUEReserved
K
KEY
KEY_MEMBER
KEY_TYPE
KILL
LABEL
LAGReservedReserved
LANGUAGEReserved
LARGEReserved
LAST
LAST_VALUEReservedReserved
LATERALReserved
LEADReservedReserved
LEADINGReservedReserved
LEFTReservedReserved
LENGTH
LEVEL
LIBRARY
LIKEReservedReserved
LIKE_REGEXReserved
LIMITReserved
LISTAGGReserved
LNReservedReserved
LOCALReserved
LOCALTIMEReservedReserved
LOCALTIMESTAMPReservedReserved
LOCATOR
LOWERReservedReserved
M
MAP
MAPPING
MATCHReserved
MATCHED
MATCHESReserved
MATCH_CONDITIONReserved
MATCH_NUMBERReserved
MATCH_RECOGNIZEReservedReserved
MAXReservedReserved
MAXVALUE
MEASUREReserved
MEASURES
MEMBERReserved
MERGEReservedReserved
MESSAGE_LENGTH
MESSAGE_OCTET_LENGTH
MESSAGE_TEXT
METHODReserved
MICROSECOND
MILLENNIUM
MILLISECOND
MINReservedReserved
MINUSReserved
MINUTEReservedReserved
MINUTES
MINVALUE
MODReservedReserved
MODE
MODIFIESReserved
MODULEReserved
MONDAYReserved
MONTHReservedReserved
MONTHS
MORE
MULTISETReservedReserved
MUMPS
NAME
NAMES
NANOSECOND
NATIONALReserved
NATURALReservedReserved
NCHARReserved
NCLOBReserved
NESTING
NEWReservedReserved
NEXTReserved
NOReserved
NODES
NONEReserved
NORMALIZEReserved
NORMALIZED
NOTReservedReserved
NTH_VALUEReservedReserved
NTILEReservedReserved
NULLReservedReserved
NULLABLE
NULLIFReservedReserved
NULLS
NUMBER
NUMERICReserved
OBJECT
OCCURRENCES_REGEXReserved
OCTET_LENGTHReservedReserved
OCTETS
OFReserved
OFF
OFFSETReserved
OLDReserved
OMITReserved
ONReservedReserved
ONEReserved
ONLYReserved
OPENReserved
OPTION
OPTIONS
ORReservedReserved
ORDERReservedReserved
ORDERING
ORDINAL
ORDINALITY
OTHERS
OUTReserved
OUTERReservedReserved
OUTPUT
OVERReservedReserved
OVERLAPSReserved
OVERLAYReserved
OVERRIDING
PAD
PARAMETERReserved
PARAMETER_MODE
PARAMETER_NAME
PARAMETER_ORDINAL_POSITION
PARAMETER_SPECIFIC_CATALOG
PARAMETER_SPECIFIC_NAME
PARAMETER_SPECIFIC_SCHEMA
PARTIAL
PARTITIONReservedReserved
PARTITIONS
PASCAL
PASSING
PASSTHROUGH
PAST
PATH
PATTERNReserved
PERReserved
PERCENTReserved
PERCENTILE_CONTReservedReserved
PERCENTILE_DISCReservedReserved
PERCENT_RANKReservedReserved
PERIODReservedReserved
PERMUTEReserved
PIVOT
PLACING
PLAN
PLI
PORTIONReserved
POSITIONReserved
POSITION_REGEXReserved
POWERReservedReserved
PRECEDESReserved
PRECEDING
PRECISIONReservedReserved
PREPAREReserved
PRESERVE
PREV
PRIMARYReservedReserved
PRIOR
PRIVILEGES
PROCEDUREReserved
PROFILE
PROFILES
PTFReserved
PUBLIC
QUALIFYReserved
QUARTER
QUARTERS
QUERY
QUORUM
RANGEReserved
RANKReservedReserved
READ
READSReserved
REALReserved
RECURSIVEReserved
REFReserved
REFERENCESReserved
REFERENCINGReserved
REGR_AVGXReserved
REGR_AVGYReserved
REGR_COUNTReservedReserved
REGR_INTERCEPTReserved
REGR_R2Reserved
REGR_SLOPEReserved
REGR_SXXReservedReserved
REGR_SXYReserved
REGR_SYYReservedReserved
RELATIVE
RELEASEReserved
RENAMEReserved
REPEATABLE
REPLACE
REPLICAS
RESETReserved
RESPECT
RESTART
RESTRICT
RESULTReserved
RETURNReserved
RETURNED_CARDINALITY
RETURNED_LENGTH
RETURNED_OCTET_LENGTH
RETURNED_SQLSTATE
RETURNING
RETURNSReserved
REVOKEReserved
RIGHTReservedReserved
RLIKE
ROLE
ROLLBACKReserved
ROLLUPReservedReserved
ROUTINE
ROUTINE_CATALOG
ROUTINE_NAME
ROUTINE_SCHEMA
ROWReservedReserved
ROWSReserved
ROW_COUNT
ROW_NUMBERReservedReserved
RUNNINGReserved
SAFE_CAST
SAFE_OFFSET
SAFE_ORDINAL
SATURDAYReserved
SAVEPOINTReserved
SCALAR
SCALE
SCHEMA
SCHEMA_NAME
SCOPEReserved
SCOPE_CATALOGS
SCOPE_NAME
SCOPE_SCHEMA
SCROLLReserved
SEARCHReserved
SECONDReservedReserved
SECONDS
SECTION
SECURITY
SEEK
SELECTReservedReserved
SELF
SENSITIVEReserved
SEPARATOR
SEQUENCE
SERIALIZABLE
SERVER
SERVER_NAME
SESSION
SESSION_USERReservedReserved
SETReservedReserved
SETS
SHOWReserved
SIMILARReserved
SIMPLE
SIZE
SKIPReserved
SMALLINTReserved
SOMEReservedReserved
SORTED
SOURCE
SPACE
SPECIFICReservedReserved
SPECIFICTYPEReserved
SPECIFIC_NAME
SQLReserved
SQLEXCEPTIONReserved
SQLSTATEReserved
SQLWARNINGReserved
SQL_BIGINT
SQL_BINARY
SQL_BIT
SQL_BLOB
SQL_BOOLEAN
SQL_CHAR
SQL_CLOB
SQL_DATE
SQL_DECIMAL
SQL_DOUBLE
SQL_FLOAT
SQL_INTEGER
SQL_INTERVAL_DAY
SQL_INTERVAL_DAY_TO_HOUR
SQL_INTERVAL_DAY_TO_MINUTE
SQL_INTERVAL_DAY_TO_SECOND
SQL_INTERVAL_HOUR
SQL_INTERVAL_HOUR_TO_MINUTE
SQL_INTERVAL_HOUR_TO_SECOND
SQL_INTERVAL_MINUTE
SQL_INTERVAL_MINUTE_TO_SECOND
SQL_INTERVAL_MONTH
SQL_INTERVAL_SECOND
SQL_INTERVAL_YEAR
SQL_INTERVAL_YEAR_TO_MONTH
SQL_LONGVARBINARY
SQL_LONGVARCHAR
SQL_LONGVARNCHAR
SQL_NCHAR
SQL_NCLOB
SQL_NUMERIC
SQL_NVARCHAR
SQL_REAL
SQL_SMALLINT
SQL_TIME
SQL_TIMESTAMP
SQL_TINYINT
SQL_TSI_DAY
SQL_TSI_FRAC_SECOND
SQL_TSI_HOUR
SQL_TSI_MICROSECOND
SQL_TSI_MINUTE
SQL_TSI_MONTH
SQL_TSI_QUARTER
SQL_TSI_SECOND
SQL_TSI_WEEK
SQL_TSI_YEAR
SQL_VARBINARY
SQL_VARCHAR
SQRTReservedReserved
STARTReserved
STATE
STATEMENT
STATICReserved
STDDEV_POPReservedReserved
STDDEV_SAMPReservedReserved
STORAGE
STREAMReserved
STRING_AGG
STRUCTURE
STYLE
SUBCLASS_ORIGIN
SUBMULTISETReserved
SUBSETReserved
SUBSTITUTE
SUBSTRINGReservedReserved
SUBSTRING_REGEXReserved
SUCCEEDSReserved
SUMReservedReserved
SUNDAYReserved
SYMMETRICReservedReserved
SYSTEMReserved
SYSTEM_TIMEReservedReserved
SYSTEM_USERReservedReserved
TABLEReservedReserved
TABLESAMPLEReservedReserved
TABLE_NAME
TEMPORARY
THENReservedReserved
THURSDAYReserved
TIES
TIMEReservedReserved
TIMESTAMPReservedReserved
TIMESTAMPADD
TIMESTAMPDIFF
TIMESTAMP_DIFF
TIMESTAMP_TRUNC
TIMEZONE_HOURReserved
TIMEZONE_MINUTEReserved
TIME_DIFF
TIME_TRUNC
TINYINT
TOReservedReserved
TOP_LEVEL_COUNT
TRAILINGReservedReserved
TRANSACTION
TRANSACTIONS_ACTIVE
TRANSACTIONS_COMMITTED
TRANSACTIONS_ROLLED_BACK
TRANSFORM
TRANSFORMS
TRANSLATEReserved
TRANSLATE_REGEXReserved
TRANSLATIONReserved
TREATReserved
TRIGGERReserved
TRIGGER_CATALOG
TRIGGER_NAME
TRIGGER_SCHEMA
TRIMReserved
TRIM_ARRAYReserved
TRUEReservedReserved
TRUNCATEReservedReserved
TRY_CAST
TUESDAYReserved
TUMBLE
TYPE
UESCAPEReservedReserved
UNBOUNDED
UNCOMMITTED
UNCONDITIONAL
UNDER
UNIONReservedReserved
UNIQUEReserved
UNKNOWNReservedReserved
UNNAMED
UNNESTReserved
UNPIVOT
UP
UPDATEReservedReserved
UPPERReservedReserved
UPSERTReserved
USAGE
USERReservedReserved
USER_DEFINED_TYPE_CATALOG
USER_DEFINED_TYPE_CODE
USER_DEFINED_TYPE_NAME
USER_DEFINED_TYPE_SCHEMA
USINGReservedReserved
UTF16
UTF32
UTF8
UUIDReserved
VALUEReservedReserved
VALUESReservedReserved
VALUE_OFReserved
VARBINARYReserved
VARCHARReserved
VARIANTReserved
VARYINGReserved
VAR_POPReservedReserved
VAR_SAMPReservedReserved
VERSION
VERSIONINGReserved
VIEW
WAIT
WEDNESDAYReserved
WEEK
WEEKS
WHENReservedReserved
WHENEVERReserved
WHEREReservedReserved
WIDTH_BUCKET
WINDOWReservedReserved
WITHReservedReserved
WITHINReservedReserved
WITHOUTReserved
WORKReserved
WRAPPER
WRITEReserved
XMLReserved
XMLAGGReserved
XMLATTRIBUTESReserved
XMLBINARYReserved
XMLCASTReserved
XMLCOMMENTReserved
XMLCONCATReserved
XMLDOCUMENTReserved
XMLELEMENTReserved
XMLEXISTSReserved
XMLFORESTReserved
XMLITERATEReserved
XMLNAMESPACESReserved
XMLPARSEReserved
XMLPIReserved
XMLQUERYReserved
XMLSERIALIZEReserved
XMLTABLEReserved
XMLTEXTReserved
XMLVALIDATEReserved
YEARReservedReserved
YEARS
ZONE