set_col_immutable

Type of operation: Metadata

Description

Mark resource columns as time immutable (time-invariant), or not.

Arguments are colname:bool where the bool value must be known at compile time.

A time immutable column is a column that does not change for a given resource instance (as identified by the resource primary key). All key columns are implicitly immutable. Columns that are immutable can be stored and processed more efficiently.

Beware: manually marking mutable columns as immutable can lead to wrong query results.

Usage

set_col_immutable col_1, col_2, ...

Argument

Type

Optional

Repeatable

Restrictions

col

expression

no

yes

none

Accelerable

set_col_immutable 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

set_col_immutable hostname:true, IP:false

Marks the column hostname as immutable, and the column IP as mutable.

Aliases

  • colimmutable (deprecated)