IDSET data type

IDSET is a FeatureBase datatype used with timeQuantum and ttl constraints.

DDL syntax

IDSET

Arguments

Argument	Description
IDSET	Data type used where there is a need to set multiple ID values for a single column

Additional information

The IDSET data type:

has a set internal data type
is used for:
- grouping by
- searching for discrete values

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