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

STRINGSET data type

STRINGSET is a FeatureBase datatype used for a set of strings.

DDL Syntax



Argument Description
STRINGSET Data type used to set multiple STRING values for a single column.

Additional information

The STRINGSET data type:

  • has a keyed set internal datatype
  • is used when:
    • grouping by
    • searching for 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'
  comment 'table containing all column types';