Reserved Keywords
Dremio reserves ANSI keywords and additional keywords to perform SQL queries on datalake sources and relational databases. These reserved keywords are part of the grammar of the SQL language that is used by Dremio to parse and understand SQL statements.
However, you can use these reserved keywords as an object name by enclosing a keyword in double quotes (for example, "boolean"
).
ALL | ALLOCATE | ALLOW | ALTER |
ANALYZE | ANY | ARE | ARRAY |
ARRAY_MAX_CARDINALITY | AS | ASENSITIVE | ASYMMETRIC |
AT | ATOMIC | AUTHORIZATION | BEGIN |
BEGIN_FRAME | BEGIN_PARTITION | BETWEEN | BIGINT |
BINARY | BIT | BLOB | BOOLEAN |
BOTH | BY | CALL | CALLED |
CARDINALITY | CASCADED | CASE | CAST |
CEILING | CHAR | CHARACTER | CHECK |
CLASSIFIER | CLOB | CLOSE | COALESCE |
COLLATE | COLLECT | COMMIT | COMPACT |
COMPUTE | CONDITION | CONNECT | CONSTRAINT |
CONVERT | CORRESPONDING | CREATE | CROSS |
CUBE | CUME_DIST | CURRENT | CURRENT_CATALOG |
CURRENT_DEFAULT_TRANSFORM_GROUP | CURRENT_PATH | CURRENT_ROLE | CURRENT_ROW |
CURRENT_TRANSFORM_GROUP_FOR_TYPE | CURRENT_USER | CURSOR | CYCLE |
DATABASES | DATE | DAY | DEALLOCATE |
DEC | DECIMAL | DECLARE | DEFAULT |
DEFINE | DELETE | DENSE_RANK | DEREF |
DESCRIBE | DETERMINISTIC | DISALLOW | DISCONNECT |
DISTINCT | DOUBLE | DROP | DYNAMIC |
EACH | ELEMENT | ELSE | EMPTY |
END | END-EXEC | END_FRAME | END_PARTITION |
EQUALS | ESCAPE | EXCEPT | EXEC |
EXECUTE | EXISTS | EXPLAIN | EXTEND |
EXTERNAL | EXTRACT | FALSE | FETCH |
FILES | FILTER | FIRST_VALUE | FLOAT |
FOR | FOREIGN | FRAME_ROW | FREE |
FROM | FULL | FUNCTION | FUSION |
GET | GLOBAL | GRANT | GROUP |
GROUPING | GROUPS | HAVING | HOLD |
HOUR | IDENTITY | IF | IMPORT |
IN | INCLUDE | INDICATOR | INITIAL |
INNER | INOUT | INSENSITIVE | INSERT |
INT | INTEGER | INTERSECT | INTERSECTION |
INTERVAL | INTO | IS | JOIN |
LAG | LANGUAGE | LARGE | LAST_VALUE |
LATERAL | LEAD | LEADING | LIKE_REGEX |
LIMIT | LN | LOAD | LOCAL |
MATCH | MATCHES | MATCH_NUMBER | MATCH_RECOGNIZE |
MEMBER | MERGE | METADATA | METHOD |
MINUS | MINUTE | MODIFIES | MODULE |
MONTH | MULTISET | NATIONAL | NATURAL |
NCHAR | NCLOB | NEW | NEXT |
NO | NONE | NORMALIZE | NTH_VALUE |
NTILE | NULL | NULLIF | NUMERIC |
OCCURRENCES_REGEX | OF | OFFSET | OLD |
OMIT | ON | ONE | ONLY |
OPEN | ORDER | OUT | OUTER |
OVER | OVERLAPS | OVERLAY | PARAMETER |
PARTITION | PARTITIONS | PATTERN | PER |
PERCENT | PERCENTILE_CONT | PERCENTILE_DISC | PERCENT_RANK |
PERIOD | PERMUTE | PIVOT | PORTION |
POSITION_REGEX | PRECEDES | PRECISION | PREPARE |
PREV | PRIMARY | PROCEDURE | RANGE |
RANK | READS | REAL | RECURSIVE |
REF | REFERENCES | REFERENCING | REFRESH |
REGR_AVGX | REGR_AVGY | REGR_COUNT | REGR_INTERCEPT |
REGR_R2 | REGR_SLOPE | REGR_SXX | REGR_SXY |
REGR_SYY | RELEASE | RESET | RESULT |
RETURN | RETURNS | REVOKE | ROLLBACK |
ROLLUP | ROW | ROWS | ROW_NUMBER |
RUNNING | SAVEPOINT | SCHEMAS | SCOPE |
SCROLL | SEARCH | SECOND | SEEK |
SELECT | SENSITIVE | SET | SHOW |
SKIP | SMALLINT | SOME | SPECIFIC |
SPECIFICTYPE | SQL | SQLEXCEPTION | SQLSTATE |
SQLWARNING | START | STATIC | STATISTICS |
STREAM | SUBMULTISET | SUBSET | SUBSTRING_REGEX |
SUCCEEDS | SYMMETRIC | SYSTEM | SYSTEM_TIME |
TABLE | TABLES | TABLESAMPLE | THEN |
TIME | TIMESTAMP | TIMEZONE_HOUR | TIMEZONE_MINUTE |
TINYINT | TO | TRAILING | TRANSLATE |
TRANSLATE_REGEX | TRANSLATION | TREAT | TRIGGER |
TRIM | TRIM_ARRAY | TRUE | UESCAPE |
UNION | UNIQUE | UNKNOWN | UNNEST |
UNPIVOT | UNSET | UPDATE | UPSERT |
USE | USING | VALUE | VALUES |
VALUE_OF | VARBINARY | VARCHAR | VARYING |
VERSIONING | WHEN | WHENEVER | WHERE |
WIDTH_BUCKET | WINDOW | WITH | WITHIN |
WITHOUT | YEAR |