set_col_searchable

Type of operation: Metadata

Description

Include or exclude columns from any future full-text search operation (e.g., filter * ~ error). By default a full-text operation searches in all columns, and this verb can be used to improve search performance by excluding columns that do not need to be searched. Arguments are colname:bool where the bool value must be a literal true or false.

Usage

set_col_searchable col ...

Argument

Type

Required

Multiple

Constant

col

expression

Required

Can be multiple

Variable

Accelerable

set_col_searchable 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_searchable cluster_uid:false, cluster_index:false

Exclude columns cluster_uid and cluster_index from future fulltext searches. For instance, a further filter operation filter * ~ error will not search error in these two columns.