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}]

Arguments

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.

Examples

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';