Note
This documentation is for a prior release of Kinetica. For the latest documentation, click here.
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:
| |
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
