Keywords and Reserved Words

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

  • Common Keywords

  • ADD

  • AFTER
  • ALIAS
  • ALIGN
  • ALIGNED
  • ALL
  • ALTER
  • ANY
  • AS
  • ASC
  • ATTRIBUTES
  • AUTOREGISTER
  • BEFORE
  • BEGIN
  • BY
  • CACHE
  • CHILD
  • CLEAR
  • COMPRESSION
  • COMPRESSOR
  • CONCAT
  • CONFIGURATION
  • CONTINUOUS
  • COUNT
  • CONTAIN
  • CQ
  • CQS
  • CREATE
  • DATATYPE
  • DEBUG
  • DELETE
  • DESC
  • DESCRIBE
  • DEVICE
  • DEVICES
  • DISABLE
  • DROP
  • ENCODING
  • END
  • EVERY
  • EXPLAIN
  • FILL
  • FLUSH
  • FOR
  • FROM
  • FULL
  • FUNCTION
  • FUNCTIONS
  • GLOBAL
  • GRANT
  • GROUP
  • INDEX
  • INFO
  • INSERT
  • INTO
  • KILL
  • LABEL
  • LAST
  • LATEST
  • LEVEL
  • LIKE
  • LIMIT
  • LINEAR
  • LINK
  • LIST
  • LOAD
  • LOCK
  • MERGE
  • METADATA
  • NODES
  • NOW
  • OF
  • OFF
  • OFFSET
  • ON
  • ORDER
  • PARTITION
  • PASSWORD
  • PATHS
  • PREVIOUS
  • PREVIOUSUNTILLAST
  • PRIVILEGES
  • PROCESSLIST
  • PROPERTY
  • QUERIES
  • QUERY
  • READONLY
  • REGEXP
  • REMOVE
  • RENAME
  • RESAMPLE
  • REVOKE
  • ROLE
  • ROOT (R)
  • SCHEMA
  • SELECT
  • SET
  • SETTLE
  • SGLEVEL
  • SHOW
  • SLIMIT
  • SNAPSHOT
  • SOFFSET
  • STORAGE
  • START
  • STOP
  • SYSTEM
  • TAGS
  • TASK
  • TEMPLATE
  • TIME (R)
  • TIMESERIES
  • TIMESTAMP (R)
  • TO
  • TOLERANCE
  • TOP
  • TRACING
  • TRIGGER
  • TRIGGERS
  • TTL
  • UNLINK
  • UNLOAD
  • UNSET
  • UPDATE
  • UPSERT
  • USER
  • USING
  • VALUES
  • VERIFY
  • VERSION
  • WATERMARK_EMBEDDING
  • WHERE
  • WITH
  • WITHOUT
  • WRITABLE

  • Data Type Keywords

  • BOOLEAN

  • DOUBLE
  • FLOAT
  • INT32
  • INT64
  • TEXT

  • Encoding Type Keywords

  • DICTIONARY

  • DIFF
  • GORILLA
  • PLAIN
  • REGULAR
  • RLE
  • TS_2DIFF

  • Compressor Type Keywords

  • GZIP

  • LZ4
  • SNAPPY
  • UNCOMPRESSED

  • Privileges Keywords

  • SET_STORAGE_GROUP

  • CREATE_TIMESERIES
  • INSERT_TIMESERIES
  • READ_TIMESERIES
  • DELETE_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