Help Center/ Data Lake Insight/ Flink SQL Syntax Reference/ Historical Version/ Flink SQL Syntax (This Syntax Will Not Evolve. Use FlinkOpenSource SQL Instead.)/ Reserved Keywords
Updated on 2024-08-19 GMT+08:00
View PDF

Reserved Keywords

Flink SQL reserves some strings as keywords. If you want to use the following strings as field names, ensure that they are enclosed by back quotes, for example, `value` and `count`.

A

  • A
  • ABS
  • ABSOLUTE
  • ACTION
  • ADA
  • ADD
  • ADMIN
  • AFTER
  • AK
  • ALL
  • ALLOCATE
  • ALLOW
  • ALTER
  • ALWAYS
  • AND
  • ANY
  • APPEND
  • APP_ID
  • ARE
  • ARRAY
  • ARRAY_BRACKET
  • AS
  • ASC
  • ASENSITIVE
  • ASSERTION
  • ASSIGNMENT
  • ASYMMETRIC
  • AT
  • AT_LEAST_ONCE
  • ATOMIC
  • ATTRIBUTE
  • ATTRIBUTES
  • AUTHORIZATION
  • AVG
  • AVRO_CONFIG
  • AVRO_DATA
  • AVRO_SCHEMA

B

  • BATCH_INSERT_DATA_NUM
  • BEFORE
  • BEGIN
  • BERNOULLI
  • BETWEEN
  • BIGINT
  • BINARY
  • BIT
  • BLOB
  • BOOL
  • BOOLEAN
  • BOTH
  • BREADTH
  • BUCKET
  • BY

C

  • C
  • CACHE_MAX_NUM
  • CACHE_TIME
  • CALL
  • CALLED
  • CARDINALITY
  • CASCADE
  • CASCADED
  • CASE
  • CAST
  • CATALOG
  • CATALOG_NAME
  • CEIL
  • CEILING
  • CENTURY
  • CHAIN
  • CHANNEL
  • CHAR
  • CHARACTER
  • CHARACTERISTICTS
  • CHARACTERS
  • CHARACTER_LENGTH
  • CHARACTER_SET_CATALOG
  • CHARACTER_SET_NAME
  • CHARACTER_SET_SCHEMA
  • CHAR_LENGTH
  • CHECK
  • CHECKPOINT_APP_NAME
  • CHECKPOINT_INTERVAL
  • CHECKPOINTINTERVAL
  • CLASS_ORIGIN
  • CLOB
  • CLOSE
  • CLUSTER_ADDRESS
  • CLUSTER_ID
  • CLUSTER_NAME
  • COALESCE
  • COBOL
  • COLLATE
  • COLLATION
  • COLLATION_CATALOG
  • COLLATION_NAME
  • COLLATION_SCHEMA
  • COLLECT
  • COLUMN
  • COLUMN_NAME
  • COLUMN_NAME_MAP
  • COMMAND_FUNCTION
  • COMMAND_FUNCTION_CODE
  • COMMIT
  • COMMITTED
  • CONDITION
  • CONDITION_NUMBER
  • CONFIGURATION
  • CONFLUENT_CERTIFICATE_NAME
  • CONFLUENT_PROPERTIES
  • CONFLUENT_SCHEMA_FIELD
  • CONFLUENT_URL
  • CONNECT
  • CONNECTION_NAME
  • CONSTRAINT
  • CONSTRAINTS
  • CONSTRAINT_CATALOG
  • CONSTRAINT_NAME
  • CONSTRAINT_SCHEMA
  • CONSTRUCTOR
  • CONTAINS
  • CONTINUE
  • CONVERT
  • CORR
  • CORRESPONDING
  • COUNT
  • COVAR_POP
  • COVAR_SAMP
  • CREATE
  • CREATE_IF_NOT_EXIST
  • CROSS
  • CUBE
  • CUME_DIST
  • CURRENT
  • CURRENT_CATALOG
  • CURRENT_DATE
  • CURRENT_DEFAULT_TRANSFORM_GROUP
  • CURRENT_PATH
  • CURRENT_ROLE
  • CURRENT_SCHEMA
  • CURRENT_TIMESTAMP
  • CURRENT_TRANSFORM_GROUP_FOR_TYPE
  • CURRENT_USER
  • CURSOR
  • CURSOR_NAME
  • CYCLE

D

  • DATE
  • DATABASE
  • DATE
  • DATETIME_INTERVAL_CODE
  • DATETIME_INTERVAL_PRECISION
  • DAY
  • DB_COLUMNS
  • DB_URL
  • DB_OBS_SERVER
  • DB_TYPE
  • DEALLOCATE
  • DEC
  • DECADE
  • DECIMAL
  • DECLARE
  • DEFAULTS
  • DEFERRABLE
  • DEFERRED
  • DEFINER
  • DEGREE
  • DELETE
  • DELETE_OBS_TEMP_FILE
  • DENSE_RANK
  • DEPTH
  • DEREF
  • DERIVED
  • DESC
  • DESCRIBE
  • DESCRIPTION
  • DESCRIPTOR
  • DETERMINISTIC
  • DIAGNOSTICS
  • DISALLOW
  • DISCONNECT
  • DIS_NOTICE_CHANNEL
  • DISPATCH
  • DISTINCT
  • DOMAIN
  • DOUBLE
  • DOW
  • DOY
  • DRIVER
  • DROP
  • DUMP_INTERVAL
  • DYNAMIC
  • DYNAMIC_FUNCTION
  • DYNAMIC_FUNCTION_CODE

E

  • EACH
  • ELEMENT
  • ELSE
  • EMAIL_KEY
  • ENABLECHECKPOINT
  • ENABLE_CHECKPOINT
  • ENABLE_OUTPUT_NULL
  • ENCODE
  • ENCODE_CLASS_NAME
  • ENCODE_CLASS_PARAMETER
  • ENCODED_DATA
  • END
  • ENDPOINT
  • END_EXEC
  • EPOCH
  • EQUALS
  • ESCAPE
  • ES_FIELDS
  • ES_INDEX
  • ES_TYPE
  • ESTIMATEMEM
  • ESTIMATEPARALLELISM
  • EXACTLY_ONCE
  • EXCEPT
  • EXCEPTION
  • EXCLUDE
  • EXCLUDING
  • EXEC
  • EXECUTE
  • EXISTS
  • EXP
  • EXPLAIN
  • EXTEND
  • EXTERNAL
  • EXTRACT
  • EVERY

F

  • FALSE
  • FETCH
  • FIELD_DELIMITER
  • FIELD_NAMES
  • FILE_PREFIX
  • FILTER
  • FINAL
  • FIRST
  • FIRST_VALUE
  • FLOAT
  • FLOOR
  • FOLLOWING
  • FOR
  • FUNCTION
  • FOREIGN
  • FORTRAN
  • FOUND
  • FRAC_SECOND
  • FREE
  • FROM
  • FULL
  • FUSION

G

  • G
  • GENERAL
  • GENERATED
  • GET
  • GLOBAL
  • GO
  • GOTO
  • GRANT
  • GRANTED
  • GROUP
  • GROUPING
  • GW_URL

H

  • HASH_KEY_COLUMN
  • HAVING
  • HIERARCHY
  • HOLD
  • HOUR
  • HTTPS_PORT

I

  • IDENTITY
  • ILLEGAL_DATA_TABLE
  • IMMEDIATE
  • IMPLEMENTATION
  • IMPORT
  • IN
  • INCLUDING
  • INCREMENT
  • INDICATOR
  • INITIALLY
  • INNER
  • INOUT
  • INPUT
  • INSENSITIVE
  • INSERT
  • INSTANCE
  • INSTANTIABLE
  • INT
  • INTEGER
  • INTERSECT
  • INTERSECTION
  • INTERVAL
  • INTO
  • INVOKER
  • IN_WITH_SCHEMA
  • IS
  • ISOLATION

J

  • JAVA
  • JOIN
  • JSON_CONFIG
  • JSON_SCHEMA

K

  • K
  • KAFKA_BOOTSTRAP_SERVERS
  • KAFKA_CERTIFICATE_NAME
  • KAFKA_GROUP_ID
  • KAFKA_PROPERTIES
  • KAFKA_PROPERTIES_DELIMITER
  • KAFKA_TOPIC
  • KEY
  • KEY_COLUMN
  • KEY_MEMBER
  • KEY_TYPE
  • KEY_VALUE
  • KRB_AUTH

L

  • LABEL
  • LANGUAGE
  • LARGE
  • LAST
  • LAST_VALUE
  • LATERAL
  • LEADING
  • LEFT
  • LENGTH
  • LEVEL
  • LIBRARY
  • LIKE
  • LIMIT
  • LONG

M

  • M
  • MAP
  • MATCH
  • MATCHED
  • MATCHING_COLUMNS
  • MATCHING_REGEX
  • MAX
  • MAXALLOWEDCPU
  • MAXALLOWEDMEM
  • MAXALLOWEDPARALLELISM
  • MAX_DUMP_FILE_NUM
  • MAX_RECORD_NUM_CACHE
  • MAX_RECORD_NUM_PER_FILE
  • MAXVALUE
  • MEMBER
  • MERGE
  • MESSAGE_COLUMN
  • MESSAGE_LENGTH
  • MESSAGE_OCTET_LENGTH
  • MESSAGE_SUBJECT
  • MESSAGE_TEXT
  • METHOD
  • MICROSECOND
  • MILLENNIUM
  • MIN
  • MINUTE
  • MINVALUE
  • MOD
  • MODIFIES
  • MODULE
  • MONTH
  • MORE
  • MS
  • MULTISET
  • MUMPS

N

  • NAME
  • NAMES
  • NATIONAL
  • NATURAL
  • NCHAR
  • NCLOB
  • NESTING
  • NEW
  • NEXT
  • NO
  • NONE
  • NORMALIZE
  • NORMALIZED
  • NOT
  • NULL
  • NULLABLE
  • NULLIF
  • NULLS
  • NUMBER
  • NUMERIC

O

  • OBJECT
  • OBJECT_NAME
  • OBS_DIR
  • OCTETS
  • OCTET_LENGTH
  • OF
  • OFFSET
  • OLD
  • ON
  • ONLY
  • OPEN
  • OPERATION_FIELD
  • OPTION
  • OPTIONS
  • OR
  • ORDER
  • ORDERING
  • ORDINALITY
  • OTHERS
  • OUT
  • OUTER
  • OUTPUT
  • OVER
  • OVERLAPS
  • OVERLAY
  • OVERRIDING

P

  • PAD
  • PARALLELISM
  • PARAMETER
  • PARAMETER_MODE
  • PARAMETER_NAME
  • PARAMETER_ORDINAL_POSITION
  • PARAMETER_SPECIFIC_CATALOG
  • PARAMETER_SPECIFIC_NAME
  • PARAMETER_SPECIFIC_SCHEMA
  • PARTIAL
  • PARTITION
  • PARTITION_COUNT
  • PARTITION_KEY
  • PARTITION_RANGE
  • PASCAL
  • PASSTHROUGH
  • PASSWORD
  • PATH
  • PERCENTILE_CONT
  • PERCENTILE_DISC
  • PERCENT_RANK
  • PERSIST_SCHEMA
  • PIPELINE_ID
  • PLACING
  • PLAN
  • PLI
  • POSITION
  • POWER
  • PRECEDING
  • PRECISION
  • PREPARE
  • PRESERVE
  • PRIMARY
  • PRIMARY_KEY
  • PRIOR
  • PRIVILEGES
  • PROCEDURE
  • PROCTIME
  • PROJECT_ID
  • PUBLIC

Q

  • QUARTER
  • QUOTE

R

  • RANGE
  • RANK
  • RAW
  • READ
  • READS
  • READ_ONCE
  • REAL
  • RECURSIVE
  • REF
  • REFERENCES
  • REFERENCING
  • REGION
  • REGR_AVGX
  • REGR_AVGY
  • REGR_COUNT
  • REGR_INTERCEPT
  • REGR_R2
  • REGR_SLOPE
  • REGR_SXX
  • REGR_SXY
  • REGR_SYY
  • RELATIVE
  • RELEASE
  • REPEATABLE
  • RESET
  • RESTART
  • RESTRICT
  • RESULT
  • RETURN
  • RETURNED_CARDINALITY
  • RETURNED_LENGTH
  • RETURNED_OCTET_LENGTH
  • RETURNED_SQLSTATE
  • RETURNS
  • REVOKE
  • RIGHT
  • ROLE
  • ROLLBACK
  • ROLLING_INTERVAL
  • ROLLING_SIZE
  • ROLLUP
  • ROUTINE
  • ROUTINE_CATALOG
  • ROUTINE_NAME
  • ROUTINE_SCHEMA
  • ROW
  • ROW_COUNT
  • ROW_DELIMITER
  • ROW_NUMBER
  • ROWS
  • ROWTIME

S

  • SAVEPOINT
  • SCALE
  • SCHEMA
  • SCHEMA_CASE_SENSITIVE
  • SCHEMA_NAME
  • SCOPE
  • SCOPE_CATALOGS
  • SCOPE_NAME
  • SCOPE_SCHEMA
  • SCROLL
  • SEARCH
  • SECOND
  • SECTION
  • SECURITY
  • SELECT
  • SELF
  • SENSITIVE
  • SEQUENCE
  • SERIALIZABLE
  • SERVER
  • SERVER_NAME
  • SESSION
  • SESSION_USER
  • SET
  • SETS
  • SIMILAR
  • SIMPLE
  • SINK
  • SIZE
  • SK
  • SMALLINT
  • SOME
  • SOURCE
  • SPACE
  • SPECIFIC
  • SPECIFICTYPE
  • SPECIFIC_NAME
  • SQL
  • SQLEXCEPTION
  • SQLSTATE
  • SQLWARNING
  • SQL_TSI_DAY
  • SQL_TSI_FRAC_SECOND
  • SQL_TSI_HOUR
  • SQL_TSI_MICROSECOND
  • SQL_TSI_MINUTE
  • SQL_TSI_MONTH
  • SQL_TSI_QUARTER
  • SQL_TSI_SECOND
  • SQL_TSI_WEEK
  • SQL_TSI_YEAR
  • SQRT
  • START
  • START_TIME
  • STATE
  • STATEMENT
  • STATIC
  • STDDEV_POP
  • STDDEV_SAMP
  • STREAM
  • STRING
  • STRUCTURE
  • STYLE
  • SUBCLASS_ORIGIN
  • SUBMULTISET
  • SUBSTITUTE
  • SUBSTRING
  • SUM
  • SYMMETRIC
  • SYSTEM
  • SYSTEM_USER

T

  • TABLE
  • TABLESAMPLE
  • TABLE_COLUMNS
  • TABLE_NAME
  • TABLE_NAME_MAP
  • TEMP
  • TEMPORARY
  • THEN
  • TIES
  • TIME
  • TIMESTAMP
  • TIMESTAMPADD
  • TIMESTAMPDIFF
  • TIMEZONE_HOUR
  • TIMEZONE_MINUTE
  • TINYINT
  • TO
  • TOP_LEVEL_COUNT
  • TOPIC
  • TOPIC_URN
  • TRAILING
  • TRANSACTION
  • TRANSACTIONAL_TABLE
  • TRANSACTIONS_ACTIVE
  • TRANSACTIONS_COMMITTED
  • TRANSACTIONS_ROLLED_BACK
  • TRANSFORM
  • TRANSFORMS
  • TRANSLATE
  • TRANSLATION
  • TRANX_ID
  • TREAT
  • TRIGGER
  • TRIGGER_CATALOG
  • TRIGGER_NAME
  • TRIGGER_SCHEMA
  • TRIM
  • TRUE
  • TSDB_LINK_ADDRESS
  • TSDB_METRICS
  • TSDB_TIMESTAMPS
  • TSDB_TAGS
  • TSDB_VALUES
  • TYPE
  • TYPE_CLASS_NAME
  • TYPE_CLASS_PARAMETER

U

  • UESCAPE
  • UNBOUNDED
  • UNCOMMITTED
  • UNDER
  • UNION
  • UNIQUE
  • UNKNOWN
  • UNNAMED
  • UNNEST
  • UPDATE
  • UPPER
  • UPSERT
  • URN_COLUMN
  • USAGE
  • USER
  • USER_DEFINED_TYPE_CATALOG
  • USER_DEFINED_TYPE_CODE
  • USER_DEFINED_TYPE_NAME
  • USER_DEFINED_TYPE_SCHEMA
  • USERNAME
  • USING

V

  • VALUE
  • VALUES
  • VALUE_TYPE
  • VARBINARY
  • VARCHAR
  • VARYING
  • VAR_POP
  • VAR_SAMP
  • VERSION
  • VERSION_ID
  • VIEW

W

  • WATERMARK
  • WEEK
  • WHEN
  • WHENEVER
  • WHERE
  • WIDTH_BUCKET
  • WINDOW
  • WITH
  • WITHIN
  • WITHOUT
  • WORK
  • WRAPPER
  • WRITE

X

  • XML
  • XML_CONFIG

Y

  • YEAR

Z

  • ZONE