> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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:

```sql theme={null}
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`