GridGain Developers Hub

Keywords

This topic covers keywords in GridGain 9.

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 GridGain 9.1.10.

Keyword GridGain 9 SQL 2016

A

ABS

Reserved

Reserved

ABSENT

Reserved

ABSOLUTE

ACTION

ADA

ADD

ADMIN

AFTER

ALGORITHM

ALL

Reserved

Reserved

ALLOCATE

Reserved

ALLOW

ALTER

Reserved

Reserved

ALWAYS

AND

Reserved

Reserved

ANY

Reserved

Reserved

APPLY

ARE

Reserved

ARRAY

Reserved

Reserved

ARRAY_AGG

Reserved

ARRAY_CONCAT_AGG

ARRAY_MAX_CARDINALITY

Reserved

Reserved

AS

Reserved

Reserved

ASC

Reserved

ASENSITIVE

Reserved

ASOF

Reserved

ASSERTION

ASSIGNMENT

ASYMMETRIC

Reserved

Reserved

AT

Reserved

ATOMIC

Reserved

ATTRIBUTE

ATTRIBUTES

AUTHORIZATION

Reserved

AUTO

AVG

Reserved

Reserved

BEFORE

BEGIN

Reserved

BEGIN_FRAME

Reserved

BEGIN_PARTITION

Reserved

BERNOULLI

BETWEEN

Reserved

Reserved

BIGINT

Reserved

BINARY

Reserved

BIT

BLOB

Reserved

BOOLEAN

Reserved

BOTH

Reserved

Reserved

BREADTH

BY

Reserved

Reserved

C

CACHE

Reserved

CALL

Reserved

Reserved

CALLED

Reserved

CARDINALITY

Reserved

Reserved

CASCADE

Reserved

CASCADED

Reserved

CASE

Reserved

Reserved

CAST

Reserved

Reserved

CATALOG

CATALOG_NAME

CEIL

CEILING

Reserved

Reserved

CENTURY

CHAIN

CHAR

Reserved

Reserved

CHARACTER

Reserved

Reserved

CHARACTERISTICS

CHARACTERS

CHARACTER_LENGTH

Reserved

Reserved

CHARACTER_SET_CATALOG

CHARACTER_SET_NAME

CHARACTER_SET_SCHEMA

CHAR_LENGTH

Reserved

Reserved

CHECK

Reserved

CLASSIFIER

Reserved

CLASS_ORIGIN

CLOB

Reserved

CLOSE

Reserved

COALESCE

Reserved

Reserved

COBOL

COLLATE

Reserved

COLLATION

COLLATION_CATALOG

COLLATION_NAME

COLLATION_SCHEMA

COLLECT

Reserved

Reserved

COLOCATE

COLUMN

Reserved

Reserved

COLUMN_NAME

COMMAND_FUNCTION

COMMAND_FUNCTION_CODE

COMMIT

Reserved

COMMITTED

COMPUTE

CONDITION

Reserved

CONDITIONAL

Reserved

CONDITION_NUMBER

CONNECT

Reserved

CONNECTION

CONNECTION_NAME

CONSISTENCY

CONSTRAINT

Reserved

Reserved

CONSTRAINTS

CONSTRAINT_CATALOG

CONSTRAINT_NAME

CONSTRAINT_SCHEMA

CONSTRUCTOR

CONTAINS

Reserved

CONTAINS_SUBSTR

CONTINUE

CONVERT

Reserved

Reserved

CORR

Reserved

CORRESPONDING

Reserved

COUNT

Reserved

Reserved

COVAR_POP

Reserved

Reserved

COVAR_SAMP

Reserved

Reserved

CREATE

Reserved

Reserved

CROSS

Reserved

Reserved

CUBE

Reserved

Reserved

CUME_DIST

Reserved

Reserved

CURRENT

Reserved

Reserved

CURRENT_CATALOG

Reserved

Reserved

CURRENT_DATE

Reserved

Reserved

CURRENT_DEFAULT_TRANSFORM_GROUP

Reserved

Reserved

CURRENT_PATH

Reserved

Reserved

CURRENT_ROLE

Reserved

Reserved

CURRENT_ROW

Reserved

Reserved

CURRENT_SCHEMA

Reserved

Reserved

CURRENT_TIME

Reserved

Reserved

CURRENT_TIMESTAMP

Reserved

Reserved

CURRENT_TRANSFORM_GROUP_FOR_TYPE

Reserved

Reserved

CURRENT_USER

Reserved

Reserved

CURSOR

Reserved

CURSOR_NAME

CYCLE

Reserved

DATA

DATABASE

DATALINK

Reserved

DATE

Reserved

Reserved

DATETIME

Reserved

DATETIME_DIFF

DATETIME_INTERVAL_CODE

DATETIME_INTERVAL_PRECISION

DATETIME_TRUNC

DATE_DIFF

DATE_TRUNC

DAY

Reserved

DAYOFWEEK

DAYOFYEAR

DAYS

DEALLOCATE

Reserved

DEC

Reserved

DECADE

DECFLOAT

Reserved

DECIMAL

Reserved

Reserved

DECLARE

Reserved

DEFAULT

Reserved

Reserved

DEFAULTS

DEFERRABLE

DEFERRED

DEFINE

Reserved

DEFINED

DEFINER

DEGREE

DELETE

Reserved

Reserved

DENSE_RANK

Reserved

Reserved

DEPTH

DEREF

Reserved

DERIVED

DESC

DESCRIBE

Reserved

Reserved

DESCRIPTION

DESCRIPTOR

DETERMINISTIC

DIAGNOSTICS

DISALLOW

DISCONNECT

Reserved

DISPATCH

DISTINCT

Reserved

Reserved

DISTRIBUTION

DLNEWCOPY

Reserved

DLPREVIOUSCOPY

Reserved

DLURLCOMPLETE

Reserved

DLURLCOMPLETEONLY

Reserved

DLURLCOMPLETEWRITE

Reserved

DLURLPATH

Reserved

DLURLPATHONLY

Reserved

DLURLPATHWRITE

Reserved

DLURLSCHEME

Reserved

DLURLSERVER

Reserved

DLVALUE

Reserved

DOMAIN

DOT

DOUBLE

Reserved

DOW

DOWN

DOY

DROP

Reserved

Reserved

DYNAMIC

Reserved

DYNAMIC_FUNCTION

DYNAMIC_FUNCTION_CODE

EACH

Reserved

ELEMENT

Reserved

Reserved

ELSE

Reserved

Reserved

EMPTY

Reserved

ENCODING

END

Reserved

END-EXEC

Reserved

END_FRAME

Reserved

END_PARTITION

Reserved

ENGINE

EPOCH

EQUALS

Reserved

ERROR

ESCAPE

Reserved

EVERY

Reserved

Reserved

EXCEPT

Reserved

Reserved

EXCEPTION

EXCLUDE

EXCLUDING

EXEC

Reserved

EXECUTE

Reserved

EXISTS

Reserved

Reserved

EXP

Reserved

Reserved

EXPLAIN

Reserved

EXTEND

Reserved

EXTERNAL

Reserved

EXTRACT

Reserved

Reserved

FALSE

Reserved

Reserved

FETCH

Reserved

Reserved

FILTER

Reserved

Reserved

FINAL

FIRST

FIRST_VALUE

Reserved

Reserved

FLOAT

Reserved

FLOOR

Reserved

Reserved

FOLLOWING

FOR

Reserved

Reserved

FOREIGN

Reserved

FORMAT

FORTRAN

FOUND

FRAC_SECOND

FRAME_ROW

Reserved

FREE

Reserved

FRIDAY

Reserved

FROM

Reserved

Reserved

FULL

Reserved

Reserved

FUNCTION

Reserved

FUSION

Reserved

Reserved

G

GENERAL

GENERATED

GEOMETRY

GET

Reserved

GLOBAL

Reserved

GO

GOTO

GRANT

Reserved

GRANTED

GROUP

Reserved

Reserved

GROUPING

Reserved

Reserved

GROUPS

Reserved

GROUP_CONCAT

HASH

HAVING

Reserved

Reserved

HIERARCHY

HOLD

Reserved

HOP

HOUR

Reserved

Reserved

HOURS

IDENTIFIED

Reserved

IDENTITY

Reserved

IF

Reserved

IGNORE

ILIKE

IMMEDIATE

IMMEDIATELY

IMPLEMENTATION

IMPORT

Reserved

IN

Reserved

Reserved

INCLUDE

INCLUDING

INCREMENT

INDEX

Reserved

INDICATOR

Reserved

INITIAL

Reserved

INITIALLY

Reserved

INNER

Reserved

Reserved

INOUT

Reserved

INPUT

INSENSITIVE

Reserved

INSERT

Reserved

Reserved

INSTANCE

INSTANTIABLE

INT

Reserved

INTEGER

Reserved

INTERSECT

Reserved

Reserved

INTERSECTION

Reserved

Reserved

INTERVAL

Reserved

Reserved

INTO

Reserved

Reserved

INVOKER

IS

Reserved

Reserved

ISODOW

ISOLATION

ISOYEAR

JAVA

JOIN

Reserved

Reserved

JSON

Reserved

JSON_ARRAY

Reserved

JSON_ARRAYAGG

Reserved

JSON_EXISTS

Reserved

JSON_OBJECT

Reserved

JSON_OBJECTAGG

Reserved

JSON_QUERY

Reserved

JSON_SCOPE

Reserved

JSON_TABLE

Reserved

JSON_TABLE_PRIMITIVE

Reserved

JSON_VALUE

Reserved

K

KEY

KEY_MEMBER

KEY_TYPE

KILL

LABEL

LAG

Reserved

Reserved

LANGUAGE

Reserved

LARGE

Reserved

LAST

LAST_VALUE

Reserved

Reserved

LATERAL

Reserved

LEAD

Reserved

Reserved

LEADING

Reserved

Reserved

LEFT

Reserved

Reserved

LENGTH

LEVEL

LIBRARY

LIKE

Reserved

Reserved

LIKE_REGEX

Reserved

LIMIT

Reserved

LISTAGG

Reserved

LN

Reserved

Reserved

LOCAL

Reserved

LOCALTIME

Reserved

Reserved

LOCALTIMESTAMP

Reserved

Reserved

LOCATOR

LOWER

Reserved

Reserved

M

MAP

MAPPING

MATCH

Reserved

MATCHED

MATCHES

Reserved

MATCH_CONDITION

Reserved

MATCH_NUMBER

Reserved

MATCH_RECOGNIZE

Reserved

Reserved

MAX

Reserved

Reserved

MAXVALUE

MEASURE

Reserved

MEASURES

MEMBER

Reserved

MERGE

Reserved

Reserved

MESSAGE_LENGTH

MESSAGE_OCTET_LENGTH

MESSAGE_TEXT

METHOD

Reserved

MICROSECOND

MILLENNIUM

MILLISECOND

MIN

Reserved

Reserved

MINUS

Reserved

MINUTE

Reserved

Reserved

MINUTES

MINVALUE

MOD

Reserved

Reserved

MODE

MODIFIES

Reserved

MODULE

Reserved

MONDAY

Reserved

MONTH

Reserved

Reserved

MONTHS

MORE

MULTISET

Reserved

Reserved

MUMPS

NAME

NAMES

NANOSECOND

NATIONAL

Reserved

NATURAL

Reserved

Reserved

NCHAR

Reserved

NCLOB

Reserved

NESTING

NEW

Reserved

Reserved

NEXT

Reserved

NO

Reserved

NODES

NONE

Reserved

NORMALIZE

Reserved

NORMALIZED

NOT

Reserved

Reserved

NTH_VALUE

Reserved

Reserved

NTILE

Reserved

Reserved

NULL

Reserved

Reserved

NULLABLE

NULLIF

Reserved

Reserved

NULLS

NUMBER

NUMERIC

Reserved

OBJECT

OCCURRENCES_REGEX

Reserved

OCTET_LENGTH

Reserved

Reserved

OCTETS

OF

Reserved

OFF

OFFSET

Reserved

OLD

Reserved

OMIT

Reserved

ON

Reserved

Reserved

ONE

Reserved

ONLY

Reserved

OPEN

Reserved

OPTION

OPTIONS

OR

Reserved

Reserved

ORDER

Reserved

Reserved

ORDERING

ORDINAL

ORDINALITY

OTHERS

OUT

Reserved

OUTER

Reserved

Reserved

OUTPUT

OVER

Reserved

Reserved

OVERLAPS

Reserved

OVERLAY

Reserved

OVERRIDING

PAD

PARAMETER

Reserved

PARAMETER_MODE

PARAMETER_NAME

PARAMETER_ORDINAL_POSITION

PARAMETER_SPECIFIC_CATALOG

PARAMETER_SPECIFIC_NAME

PARAMETER_SPECIFIC_SCHEMA

PARTIAL

PARTITION

Reserved

Reserved

PARTITIONS

PASCAL

PASSING

PASSTHROUGH

PAST

PATH

PATTERN

Reserved

PER

Reserved

PERCENT

Reserved

PERCENTILE_CONT

Reserved

Reserved

PERCENTILE_DISC

Reserved

Reserved

PERCENT_RANK

Reserved

Reserved

PERIOD

Reserved

Reserved

PERMUTE

Reserved

PIVOT

PLACING

PLAN

PLI

PORTION

Reserved

POSITION

Reserved

POSITION_REGEX

Reserved

POWER

Reserved

Reserved

PRECEDES

Reserved

PRECEDING

PRECISION

Reserved

Reserved

PREPARE

Reserved

PRESERVE

PREV

PRIMARY

Reserved

Reserved

PRIOR

PRIVILEGES

PROCEDURE

Reserved

PROFILE

PROFILES

PTF

Reserved

PUBLIC

QUALIFY

Reserved

QUARTER

QUARTERS

QUERY

QUORUM

RANGE

Reserved

RANK

Reserved

Reserved

READ

READS

Reserved

REAL

Reserved

RECURSIVE

Reserved

REF

Reserved

REFERENCES

Reserved

REFERENCING

Reserved

REGR_AVGX

Reserved

REGR_AVGY

Reserved

REGR_COUNT

Reserved

Reserved

REGR_INTERCEPT

Reserved

REGR_R2

Reserved

REGR_SLOPE

Reserved

REGR_SXX

Reserved

Reserved

REGR_SXY

Reserved

REGR_SYY

Reserved

Reserved

RELATIVE

RELEASE

Reserved

RENAME

Reserved

REPEATABLE

REPLACE

REPLICAS

RESET

Reserved

RESPECT

RESTART

RESTRICT

RESULT

Reserved

RETURN

Reserved

RETURNED_CARDINALITY

RETURNED_LENGTH

RETURNED_OCTET_LENGTH

RETURNED_SQLSTATE

RETURNING

RETURNS

Reserved

REVOKE

Reserved

RIGHT

Reserved

Reserved

RLIKE

ROLE

ROLLBACK

Reserved

ROLLUP

Reserved

Reserved

ROUTINE

ROUTINE_CATALOG

ROUTINE_NAME

ROUTINE_SCHEMA

ROW

Reserved

Reserved

ROWS

Reserved

ROW_COUNT

ROW_NUMBER

Reserved

Reserved

RUNNING

Reserved

SAFE_CAST

SAFE_OFFSET

SAFE_ORDINAL

SATURDAY

Reserved

SAVEPOINT

Reserved

SCALAR

SCALE

SCHEMA

SCHEMA_NAME

SCOPE

Reserved

SCOPE_CATALOGS

SCOPE_NAME

SCOPE_SCHEMA

SCROLL

Reserved

SEARCH

Reserved

SECOND

Reserved

Reserved

SECONDS

SECTION

SECURITY

SEEK

SELECT

Reserved

Reserved

SELF

SENSITIVE

Reserved

SEPARATOR

SEQUENCE

SERIALIZABLE

SERVER

SERVER_NAME

SESSION

SESSION_USER

Reserved

Reserved

SET

Reserved

Reserved

SETS

SHOW

Reserved

SIMILAR

Reserved

SIMPLE

SIZE

SKIP

Reserved

SMALLINT

Reserved

SOME

Reserved

Reserved

SORTED

SOURCE

SPACE

SPECIFIC

Reserved

Reserved

SPECIFICTYPE

Reserved

SPECIFIC_NAME

SQL

Reserved

SQLEXCEPTION

Reserved

SQLSTATE

Reserved

SQLWARNING

Reserved

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

SQRT

Reserved

Reserved

START

Reserved

STATE

STATEMENT

STATIC

Reserved

STDDEV_POP

Reserved

Reserved

STDDEV_SAMP

Reserved

Reserved

STORAGE

STREAM

Reserved

STRING_AGG

STRUCTURE

STYLE

SUBCLASS_ORIGIN

SUBMULTISET

Reserved

SUBSET

Reserved

SUBSTITUTE

SUBSTRING

Reserved

Reserved

SUBSTRING_REGEX

Reserved

SUCCEEDS

Reserved

SUM

Reserved

Reserved

SUNDAY

Reserved

SYMMETRIC

Reserved

Reserved

SYSTEM

Reserved

SYSTEM_TIME

Reserved

Reserved

SYSTEM_USER

Reserved

Reserved

TABLE

Reserved

Reserved

TABLESAMPLE

Reserved

Reserved

TABLE_NAME

TEMPORARY

THEN

Reserved

Reserved

THURSDAY

Reserved

TIES

TIME

Reserved

Reserved

TIMESTAMP

Reserved

Reserved

TIMESTAMPADD

TIMESTAMPDIFF

TIMESTAMP_DIFF

TIMESTAMP_TRUNC

TIMEZONE_HOUR

Reserved

TIMEZONE_MINUTE

Reserved

TIME_DIFF

TIME_TRUNC

TINYINT

TO

Reserved

Reserved

TOP_LEVEL_COUNT

TRAILING

Reserved

Reserved

TRANSACTION

TRANSACTIONS_ACTIVE

TRANSACTIONS_COMMITTED

TRANSACTIONS_ROLLED_BACK

TRANSFORM

TRANSFORMS

TRANSLATE

Reserved

TRANSLATE_REGEX

Reserved

TRANSLATION

Reserved

TREAT

Reserved

TRIGGER

Reserved

TRIGGER_CATALOG

TRIGGER_NAME

TRIGGER_SCHEMA

TRIM

Reserved

TRIM_ARRAY

Reserved

TRUE

Reserved

Reserved

TRUNCATE

Reserved

Reserved

TRY_CAST

TUESDAY

Reserved

TUMBLE

TYPE

UESCAPE

Reserved

Reserved

UNBOUNDED

UNCOMMITTED

UNCONDITIONAL

UNDER

UNION

Reserved

Reserved

UNIQUE

Reserved

UNKNOWN

Reserved

Reserved

UNNAMED

UNNEST

Reserved

UNPIVOT

UP

UPDATE

Reserved

Reserved

UPPER

Reserved

Reserved

UPSERT

Reserved

USAGE

USER

Reserved

Reserved

USER_DEFINED_TYPE_CATALOG

USER_DEFINED_TYPE_CODE

USER_DEFINED_TYPE_NAME

USER_DEFINED_TYPE_SCHEMA

USING

Reserved

Reserved

UTF16

UTF32

UTF8

UUID

Reserved

VALUE

Reserved

Reserved

VALUES

Reserved

Reserved

VALUE_OF

Reserved

VARBINARY

Reserved

VARCHAR

Reserved

VARIANT

Reserved

VARYING

Reserved

VAR_POP

Reserved

Reserved

VAR_SAMP

Reserved

Reserved

VERSION

VERSIONING

Reserved

VIEW

WAIT

WEDNESDAY

Reserved

WEEK

WEEKS

WHEN

Reserved

Reserved

WHENEVER

Reserved

WHERE

Reserved

Reserved

WIDTH_BUCKET

WINDOW

Reserved

Reserved

WITH

Reserved

Reserved

WITHIN

Reserved

Reserved

WITHOUT

Reserved

WORK

Reserved

WRAPPER

WRITE

Reserved

XML

Reserved

XMLAGG

Reserved

XMLATTRIBUTES

Reserved

XMLBINARY

Reserved

XMLCAST

Reserved

XMLCOMMENT

Reserved

XMLCONCAT

Reserved

XMLDOCUMENT

Reserved

XMLELEMENT

Reserved

XMLEXISTS

Reserved

XMLFOREST

Reserved

XMLITERATE

Reserved

XMLNAMESPACES

Reserved

XMLPARSE

Reserved

XMLPI

Reserved

XMLQUERY

Reserved

XMLSERIALIZE

Reserved

XMLTABLE

Reserved

XMLTEXT

Reserved

XMLVALIDATE

Reserved

YEAR

Reserved

Reserved

YEARS

ZONE