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)