Reserved Words
Some words are reserved in GridGain 9 SQL and cannot be used as identifiers, for example, table names or column names. If a reserved word is used as an identifier in a query, a syntax error will happen.
The following list shows the reserved words in GridGain 9.1.9.
A
-
ABS
-
ALL
-
ALTER
-
AND
-
ANY
-
ARRAY
-
ARRAY_MAX_CARDINALITY
-
AS
-
ASOF
-
ASYMMETRIC
-
AVG
B
-
BETWEEN
-
BOTH
-
BY
C
-
CACHE
-
CALL
-
CARDINALITY
-
CASE
-
CAST
-
CEILING
-
CHAR
-
CHARACTER
-
CHARACTER_LENGTH
-
CHAR_LENGTH
-
COALESCE
-
COLLECT
-
COLUMN
-
CONSTRAINT
-
CONVERT
-
COUNT
-
COVAR_POP
-
COVAR_SAMP
-
CREATE
-
CROSS
-
CUBE
-
CUME_DIST
-
CURRENT
-
CURRENT_CATALOG
-
CURRENT_DATE
-
CURRENT_DEFAULT_TRANSFORM_GROUP
-
CURRENT_PATH
-
CURRENT_ROLE
-
CURRENT_ROW
-
CURRENT_SCHEMA
-
CURRENT_TIME
-
CURRENT_TIMESTAMP
-
CURRENT_TRANSFORM_GROUP_FOR_TYPE
-
CURRENT_USER
D
-
DATE
-
DATETIME
-
DECIMAL
-
DEFAULT
-
DELETE
-
DENSE_RANK
-
DESCRIBE
-
DISTINCT
-
DROP
E
-
ELEMENT
-
ELSE
-
EVERY
-
EXCEPT
-
EXISTS
-
EXP
-
EXPLAIN
-
EXTEND
-
EXTRACT
F
-
FALSE
-
FETCH
-
FILTER
-
FIRST_VALUE
-
FLOOR
-
FOR
-
FRIDAY
-
FROM
-
FULL
-
FUSION
G
-
GROUP
-
GROUPING
H
-
HAVING
-
HOUR
I
-
IDENTIFIED
-
IF
-
IN
-
INDEX
-
INNER
-
INSERT
-
INTERSECT
-
INTERSECTION
-
INTERVAL
-
INTO
-
IS
J
-
JOIN
-
JSON_SCOPE
L
-
LAG
-
LAST_VALUE
-
LEAD
-
LEADING
-
LEFT
-
LIKE
-
LIMIT
-
LN
-
LOCALTIME
-
LOCALTIMESTAMP
-
LOWER
M
-
MATCH_CONDITION
-
MATCH_RECOGNIZE
-
MAX
-
MEASURE
-
MERGE
-
MIN
-
MINUS
-
MINUTE
-
MOD
-
MONDAY
-
MONTH
-
MULTISET
N
-
NATURAL
-
NEW
-
NEXT
-
NOT
-
NTH_VALUE
-
NTILE
-
NULL
-
NULLIF
O
-
OCTET_LENGTH
-
OFFSET
-
ON
-
OR
-
ORDER
-
OUTER
-
OVER
P
-
PARTITION
-
PERCENTILE_CONT
-
PERCENTILE_DISC
-
PERCENT_RANK
-
PERIOD
-
PERMUTE
-
POWER
-
PRECISION
-
PRIMARY
Q
-
QUALIFY
R
-
RANK
-
REGR_COUNT
-
REGR_SXX
-
REGR_SYY
-
RENAME
-
RESET
-
RIGHT
-
ROLLUP
-
ROW
-
ROW_NUMBER
S
-
SATURDAY
-
SECOND
-
SELECT
-
SESSION_USER
-
SET
-
SOME
-
SPECIFIC
-
SQRT
-
STDDEV_POP
-
STDDEV_SAMP
-
STREAM
-
SUBSTRING
-
SUM
-
SUNDAY
-
SYMMETRIC
-
SYSTEM_TIME
-
SYSTEM_USER
T
-
TABLE
-
TABLESAMPLE
-
THEN
-
THURSDAY
-
TIME
-
TIMESTAMP
-
TO
-
TRAILING
-
TRUE
-
TRUNCATE
-
TUESDAY
U
-
UESCAPE
-
UNION
-
UNKNOWN
-
UPDATE
-
UPPER
-
UPSERT
-
USER
-
USING
-
UUID
V
-
VALUE
-
VALUES
-
VARIANT
-
VAR_POP
-
VAR_SAMP
W
-
WEDNESDAY
-
WHEN
-
WHERE
-
WINDOW
-
WITH
-
WITHIN
Y
-
YEAR
© 2025 GridGain Systems, Inc. All Rights Reserved. Privacy Policy | Legal Notices. GridGain® is a registered trademark of GridGain Systems, Inc.
Apache, Apache Ignite, the Apache feather and the Apache Ignite logo are either registered trademarks or trademarks of The Apache Software Foundation.