keywords.md

Back to index

Keywords

A list of reserved words recognized by the parser for this engine.

Main clauses

COPY SELECT
INSERT
UPDATE
DELETE
CREATE
ALTER
DROP
TRUNCATE
FROM
JOIN
UNNEST
WHERE
GROUP BY
HAVING
ORDER BY
OFFSET
LIMIT ON CONFLICT DO SHOW DESCRIBE EVERY AT NEVER ALWAYS FOREACH WITHIN

Aliases and type conversion

AS
CAST
CONVERT
TRY_CAST
SAFE_CAST
::

Aggregates

COUNT
DISTINCT
SUM
AVG
MIN
MAX
OVER
PARTITION BY
FIRST_VALUE
LAST_VALUE
ARRAY_AGG

String functions

UPPER
UCASE
LOWER
LCASE
TRIM
LTRIM
RTRIM
LENGTH
SUBSTRING
SUBSTR
CONCAT
POSITION
REGEXP_LIKE
REGEXP
MATCH ... AGAINST
REPLACE
REVERSE

Math functions

ABS
ROUND
FLOOR
CEIL
CEILING
POWER
POW
SQRT
LOG
LOG10
EXP
SIGN
COS
ACOS
SIN
ASIN
TAN
ATAN
ATAN2

Conditional functions

CASE
WHEN
THEN
ELSE
END
COALESCE
ISNULL
ISNOTNULL
NULLIF

Date/Time/Datetime/Timestamp functions

INTERVAL
CURRENT_DATE
CURDATE
TODAY
NOW
CURRENT_TIME
CURTIME
CURRENT_DATETIME
CURRENT_TIMESTAMP
DATE_ADD
DATEADD
DATE_SUB
DATESUB
DATETIME_ADD
DATETIMEADD
DATETIME_SUB
DATETIMESUB
DATE_DIFF
DATEDIFF
DATE_FORMAT
DATE_PARSE
DATETIME_FORMAT
DATETIME_PARSE
DATE_TRUNC
EXTRACT

Geo functions

POINT
ST_DISTANCE
DISTANCE

Conditional operators

LIKE
RLIKE
IN
BETWEEN
NOT IN
NOT BETWEEN
IS NULL
IS NOT NULL

Logical operators

AND
OR
NOT

Back to index