set_col_immutable

Aliases: colimmutable (deprecated).

set_col_immutable [col: expression]+

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.

Categories

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.