Please use the form below to provide your feedback. Because your feedback is valuable to us, the information you submit in this form is recorded in our issue tracking system (JIRA), which is publicly available. You can track the status of your feedback using the ticket number displayed in the dialog once you submit the form.

Reserved Keywords

  • Capella Columnar
  • reference
March 23, 2025
+ 12
This topic lists the SQL++ for Capella columnar reserved keywords.

To include an identifier that is the same as a reserved keyword in a query, you must escape, or delimit, it with backtick (``) characters.

You must also delimit an identifier if it contains the dash - character, which is also used as an operator symbol.

For an example of the error that occurs when you do not escape a reserved keyword, see Syntax Errors.

The following keywords are reserved regardless of the case you use to enter them. Identifiers are case sensitive.

ALL

AND

ANY

APPLY

AS

ASC

AT

AUTOGENERATED

BETWEEN

BTREE

BUCKET

BY

CASE

CLOSED

COLLECTION

COMPACTION

COMPACT

CONNECT

CORRELATE

CREATE

DATABASE

DATASET

DATAVERSE

DECLARE

DEFINITION

DELETE

DESC

DISCONNECT

DISTINCT

DROP

ELEMENT

ELSE

END

ENFORCED

EVERY

EXCEPT

EXISTS

EXPLAIN

EXTERNAL

FEED

FILTER

FLATTEN

FOR

FROM

FULL

FUNCTION

GROUP

HAVING

HINTS

IF

INTO

IN

INDEX

INGESTION

INNER

INSERT

INTERNAL

INTERSECT

IS

JOIN

KEYWORD

KEY

LEFT

LETTING

LET

LIKE

LIMIT

LINK

LOAD

NGRAM

NODEGROUP

NOT

OFFSET

ON

OPEN

OR

ORDER

OUTER

OUTPUT

OVER

PATH

POLICY

PRE-SORTED

PRIMARY

RAW

REFRESH

RETURN

RTREE

RUN

SATISFIES

SECONDARY

SELECT

SET

SHADOW

SOME

SYNONYM

TEMPORARY

THEN

TYPE

TO

UNION

UNKNOWN

UNNEST

UPDATE

USE

USING

VALUE

WHEN

WHERE

WITH

WRITE