SQL Reserved Word List

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 ref, it must be double-quoted:

CREATE TABLE reserved_word_column_name
(
    "ref"  INT
)

A

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

B

• BEGIN
• BEGIN_FRAME
• BEGIN_PARTITION
• BETWEEN
• BIGINT
• BINARY
• BIT
• BLOB
• BOOLEAN
• BOTH
• BY

C

• CALL
• CALLED
• CARDINALITY
• CASCADED
• CASE
• CAST
• CCESS
• CEIL
• CEILING
• CHAR_LENGTH
• CHARACTER
• CHARACTER_LENGTH
• CHECK
• CLASSIFIER
• CLOB
• CLOSE
• COALESCE
• COLLATE
• COLLECT
• COLLECTION
• COLUMN
• COMMIT
• COMPRESSION
• CONDITION
• CONNECT
• CONSTRAINT
• CONVERT
• 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
• DENSE_RANK
• DEREF
• DESCRIBE
• DETERMINISTIC
• DICT
• DISALLOW
• DISCONNECT
• DISK_OPTIMIZED
• DISTINCT
• DROP
• DYNAMIC

E

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

F

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

G

• GET
• GLOBAL
• GRANT
• GROUP
• GROUPING
• GROUPS

H

• HAVING
• HOLD

I

• IDENTIFIED
• IDENTITY
• 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

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
• MORE
• 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
• 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

R

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

S

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

T

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

U

• UESCAPE
• UNION
• UNIQUE
• UNKNOWN
• UNNEST
• UNPIVOT
• 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