STRINGSET data type
STRINGSET is a FeatureBase datatype used for a set of strings.
DDL 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'
)
comment 'table containing all column types';