STRINGSET data type

STRINGSET is a FeatureBase datatype used to set multiple STRING values for a single column.

Syntax

STRINGSET

Arguments

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

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',
    vectorcol vector(768)
  )
  with comment 'table containing all column types';