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