Skip to main content Link Menu Expand (external link) Document Search Copy Copied

ID numeric datatype




Argument Description
ID Numeric data type used for unsigned integers that are between 1 and 2^63 -1

Additional information

The ID data type:

  • has a mutex internal data type
  • is used with data sets with low cardinality when:
    • grouping by
    • querying discrete values


CREATE TABLE with all data types

create table allcoltypes
    _id id,
    intcol int min 0 max 10000,
    boolcol bool,
    timestampcol timestamp timeunit 'ms',
    decimalcol decimal(2),
    stringcol string,
    stringsetcol stringset,
    stringsetcolq stringsetq timequantum 'YMD' ttl '24h',
    idcol id,
    idsetcol idset,
    idsetcolq idsetq timequantum 'YMD' ttl '24h',
    vectorcol vector(768)
  with comment 'table containing all column types';