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

1
2
3
4
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