Keywords and Reserved Words

The following list shows the keywords and reserved words in IoTDB. Reserved keywords are marked with (R).

  • Common Keywords
    • ADD
    • AFTER
    • ALIAS
    • ALIGN
    • ALIGNED
    • ALL
    • ALTER
    • ANY
    • APPEND
    • AS
    • ASC
    • ATTRIBUTES
    • BEFORE
    • BEGIN
    • BLOCKED
    • BOUNDARY
    • BY
    • CACHE
    • CHILD
    • CLEAR
    • CLUSTER
    • CONCAT
    • CONFIGNODES
    • CONFIGURATION
    • CONTINUOUS
    • COUNT
    • CONTAIN
    • CQ
    • CQS
    • CREATE
    • DATA
    • DATABASE
    • DATABASES
    • DATANODES
    • DEACTIVATE
    • DEBUG
    • DELETE
    • DESC
    • DESCRIBE
    • DEVICE
    • DEVICES
    • DISABLE
    • DISCARD
    • DROP
    • END
    • ENDTIME
    • EVERY
    • EXPLAIN
    • FILL
    • FILE
    • FLUSH
    • FOR
    • FROM
    • FULL
    • FUNCTION
    • FUNCTIONS
    • GLOBAL
    • GRANT
    • GROUP
    • HAVING
    • INDEX
    • INFO
    • INSERT
    • INTO
    • KILL
    • LABEL
    • LAST
    • LATEST
    • LEVEL
    • LIKE
    • LIMIT
    • LINEAR
    • LINK
    • LIST
    • LOAD
    • LOCAL
    • LOCK
    • MERGE
    • METADATA
    • NODES
    • NONE
    • NOW
    • OF
    • OFF
    • OFFSET
    • ON
    • ORDER
    • ONSUCCESS
    • PARTITION
    • PASSWORD
    • PATHS
    • PIPE
    • PIPES
    • PIPESINK
    • PIPESINKS
    • PIPESINKTYPE
    • POLICY
    • PREVIOUS
    • PREVIOUSUNTILLAST
    • PRIVILEGES
    • PROCESSLIST
    • PROPERTY
    • PRUNE
    • QUERIES
    • QUERY
    • RANGE
    • READONLY
    • REGEXP
    • REGIONID
    • REGIONS
    • REMOVE
    • RENAME
    • RESAMPLE
    • RESOURCE
    • REVOKE
    • ROLE
    • ROOT (R)
    • RUNNING
    • SCHEMA
    • SELECT
    • SERIESSLOTID
    • SET
    • SETTLE
    • SGLEVEL
    • SHOW
    • SLIMIT
    • SOFFSET
    • STORAGE
    • START
    • STARTTIME
    • STATELESS
    • STATEFUL
    • STOP
    • SYSTEM
    • TAGS
    • TASK
    • TEMPLATE
    • TIME (R)
    • TIMEOUT
    • TIMESERIES
    • TIMESLOTID
    • TIMESTAMP (R)
    • TO
    • TOLERANCE
    • TOP
    • TRACING
    • TRIGGER
    • TRIGGERS
    • TTL
    • UNLINK
    • UNLOAD
    • UNSET
    • UPDATE
    • UPSERT
    • URI
    • USER
    • USING
    • VALUES
    • VERIFY
    • VERSION
    • WATERMARK_EMBEDDING
    • WHERE
    • WITH
    • WITHOUT
    • WRITABLE
  • Privilege Keywords
    • SET_STORAGE_GROUP
    • DELETE_STORAGE_GROUP
    • CREATE_TIMESERIES
    • INSERT_TIMESERIES
    • READ_TIMESERIES
    • DELETE_TIMESERIES
    • ALTER_TIMESERIES
    • CREATE_USER
    • DELETE_USER
    • MODIFY_PASSWORD
    • LIST_USER
    • GRANT_USER_PRIVILEGE
    • REVOKE_USER_PRIVILEGE
    • GRANT_USER_ROLE
    • REVOKE_USER_ROLE
    • CREATE_ROLE
    • DELETE_ROLE
    • LIST_ROLE
    • GRANT_ROLE_PRIVILEGE
    • REVOKE_ROLE_PRIVILEGE
    • CREATE_FUNCTION
    • DROP_FUNCTION
    • CREATE_TRIGGER
    • DROP_TRIGGER
    • START_TRIGGER
    • STOP_TRIGGER
    • CREATE_CONTINUOUS_QUERY
    • DROP_CONTINUOUS_QUERY
    • APPLY_TEMPLATE
    • UPDATE_TEMPLATE
    • READ_TEMPLATE
    • READ_TEMPLATE_APPLICATION