SQL Reserved Word List - Kinetica Docs

Kinetica reserves the following words within its SQL context. Any tables, columns, or other named references that conflict with these must be double-quoted to be used. For instance, if using a column name of abs, it must be double-quoted:

CREATE TABLE example.quoted_reserved_word_column_name
(
    "abs" INT
)

A

ABS
ACCESS
ALL
ALLOCATE
ALLOW
ALTER
AND
ANY
ARE
ARRAY
ARRAY_MAX_CARDINALITY
AS
ASENSITIVE
ASOF
ASYMMETRIC
ATOMIC
AUTHORIZATION
AVG

B

BEGIN
BEGIN_FRAME
BEGIN_PARTITION
BETWEEN
BIGINT
BINARY
BIT
BLOB
BOOLEAN
BOTH
BUCKET
BY
BYTES

C

CALL
CALLED
CARDINALITY
CASCADED
CASE
CAST
CEIL
CEILING
CHAR_LENGTH
CHARACTER
CHARACTER_LENGTH
CHECK
CLASSIFIER
CLOB
CLOSE
COALESCE
COLLATE
COLLECT
COLLECTION
COLUMN
COMMIT
COMPRESSION
CONDITION
CONNECT
CONSTRAINT
CONVERT
COPY
CORR
CORRESPONDING
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
CURSOR
CYCLE

D

DEALLOCATE
DEC
DECLARE
DEFAULT_
DEFAULTVALUE
DEFINE
DELETE
DELIMITED
DENSE_RANK
DEREF
DESCRIBE
DETERMINISTIC
DICT
DISALLOW
DISCONNECT
DISK_OPTIMIZED
DISTINCT
DROP
DYNAMIC

E

EACH
ELEMENT
ELSE
EMPTY
END
END_EXEC
END_FRAME
END_PARTITION
EQUALS
ESCAPE
EVERY
EXCEPT
EXEC
EXECUTE
EXISTS
EXP
EXPLAIN
EXTEND
EXTERNAL
EXTRACT

F

FALSE
FETCH
FIRST_VALUE
FLOOR
FOR
FOREIGN
FORMAT
FRAME_ROW
FREE
FROM
FULL
FUNCTION
FUSION

G

GET
GLOBAL
GRANT
GROUP
GROUPING
GROUPS

H

HAVING
HOLD

I

IDENTIFIED
IDENTITY
IGNORE
IMPORT
IN
INCLUDE
INDICATOR
INITIAL
INNER
INOUT
INSENSITIVE
INSERT
INTEGER
INTERSECT
INTERSECTION
INTERVAL
INTO
IS

J

JOIN
JSON_ARRAY
JSON_ARRAYAGG
JSON_EXISTS
JSON_OBJECT
JSON_OBJECTAGG
JSON_QUERY
JSON_VALUE

K

KERBEROS

L

LAG
LANGUAGE
LARGE
LAST_VALUE
LATERAL
LEAD
LEADING
LEFT
LIKE
LIKE_REGEX
LIMIT
LN
LOCAL
LOCALTIME
LOCALTIMESTAMP
LOWER

M

MATCH
MATCH_NUMBER
MATCH_RECOGNIZE
MAX
MEASURES
MEMBER
MERGE
METHOD
MIN
MINUS
MOD
MODIFIES
MODIFY
MODULE
MOVE
MULTISET

N

NATIONAL
NATURAL
NCHAR
NCLOB
NEW
NEXT
NO
NONE
NORMALIZE
NOT
NTH_VALUE
NTILE
NULL
NULLIF
NUMERIC

O

OCCURRENCES_REGEX
OCTET_LENGTH
OF
OFFSET
OLD
OMIT
ON
ONE
ONLY
OPEN
OR
ORDER
OUT
OUTER
OVER
OVERLAPS
OVERLAY

P

PARAMETER
PARTITION
PASSWORD
PATHS
PATTERN
PER
PERCENT
PERCENT_RANK
PERCENTILE_CONT
PERCENTILE_DISC
PERIOD
PERMUTE
PIVOT
PORTION
POSITION_REGEX
POWER
PRECEDES
PRECISION
PREPARE
PREV
PRIMARY
PRIMARY_KEY
PROCEDURE
PROTECTED

Q

QUOTE_

R

RANGE
RANK
READS
REAL
RECURSIVE
REFERENCES
REFERENCING
REGR_AVGX
REGR_AVGY
REGR_COUNT
REGR_INTERCEPT
REGR_R2
REGR_SLOPE
REGR_SXX
REGR_SXY
REGR_SYY
RELEASE
RENAME
REPLICATED
RESET
RESOURCE_
RESPECT
RESULT
RETURN
REVOKE
RIGHT
ROLLBACK
ROLLUP
ROW
ROW_NUMBER
ROWS
RUNNING

S

SAVEPOINT
SCOPE
SCROLL
SEARCH
SECONDS
SEEK
SELECT
SENSITIVE
SESSION_USER
SET
SET_MINUS
SHARD
SHARD_KEY
SHOW
SIMILAR
SKIP_
SMALLINT
SOME
SPECIFIC
SPECIFICTYPE
SQL
SQL_DATETIME
SQL_TSI_MILLISECOND
SQLEXCEPTION
SQLSTATE
SQLWARNING
SQRT
START
STATIC
STATISTICS
STDDEV_POP
STDDEV_SAMP
STREAM
SUBMULTISET
SUBSET
SUBSTR
SUBSTRING
SUBSTRING_REGEX
SUCCEEDS
SUM
SYMMETRIC
SYSTEM_TIME
SYSTEM_USER

T

TABLE
TABLESAMPLE
TEXT_SEARCH
THEN
TIMEZONE_HOUR
TIMEZONE_MINUTE
TINYINT
TO
TOKEN_
TOP
TRAILING
TRANSLATE
TRANSLATE_REGEX
TRANSLATION
TREAT
TRIGGER
TRIM
TRIM_ARRAY
TRUE
TRUNCATE
TTL

U

UESCAPE
UNION
UNIQUE
UNKNOWN
UNNEST
UNPIVOT
UNSIGNED
UPDATE
UPPER
UPSERT
USER
USING

V

VALUE_OF
VALUES
VAR_POP
VAR_SAMP
VARBINARY
VARCHAR
VARYING
VERSIONING

W

WHEN
WHENEVER
WHERE
WIDTH_BUCKET
WINDOW
WITH
WITHIN
WITHOUT

​A

​B

​C

​D

​E

​F

​G

​H

​I

​J

​K

​L

​M

​N

​O

​P

​Q

​R

​S

​T

​U

​V

​W

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W