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

INT data type

Int is a numeric datatype used with the min and max constraints.

DDL Syntax

INT [MIN {value}] [MAX {value}]


Argument Description
INT Used for integer data that spans a large range of values intended for aggregate queries
MIN Minimum value constraint defaults to -2^63
MAX Maximum value constraint defaults to 2^63 -1

Additional information

INT is not suitable for queries that

  • group by
  • include data sets with low cardinality

Instead, use the ID data type.


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'
  comment 'table containing all column types';