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