make_interval¶
Type of operation: Metadata
Description¶
Creates an Interval dataset from an input Table or Event dataset. When the verb input is a Table dataset, make_interval
requires the name of the new Valid From
and Valid To
columns, and will filter results to be within the query window. When the verb input is an Event dataset, make_interval
requires the name of the new Valid To
column. make_interval
may not be used to convert a Resource dataset directly to an Interval dataset.
Usage¶
make_interval [ options ] [ , validFrom ] [ , validTo ]
Argument |
Type |
Required |
Multiple |
---|---|---|---|
options |
options |
Optional |
Only one |
validFrom |
fieldref |
Optional |
Only one |
validTo |
fieldref |
Optional |
Only one |
Options¶
Option |
Type |
Meaning |
---|---|---|
max_time_diff |
duration |
If you specify a |
Accelerable¶
make_interval is always accelerable if the input is accelerable. A dataset that only uses accelerable verbs can be accelerated, making queries on the dataset respond faster.
Examples¶
make_interval vt
Creates an Interval dataset from the input Event dataset, using the same Valid From
column as the input and using ‘vt’ as the new Valid To
column.
make_interval vf, vt
Creates an Interval dataset from the input Table dataset, using ‘vf’ as the new Valid From
column and ‘vt’ as the new Valid To
column. The output will be filtered to only include rows which overlap with the query window.