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 timestamp field different from the input timestamp, the value in the new field will be no further away from the old timestamp than this (default 1h).

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.