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