pick_col¶
Type of operation: Projection
Description¶
Exclude all columns except the specified columns from the input dataset to the output dataset. Primary key and time columns must be picked.
Usage¶
pick_col columnbinding ...
Argument |
Type |
Required |
Multiple |
---|---|---|---|
columnbinding |
expression |
Required |
Can be multiple |
Accelerable¶
pick_col 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¶
pick_col event_time:input_time, uid:data.request.sourceHost, status_code:int64(data.request.httpStatus), message:message, ok:int64(data.request.httpStatus) < 400
Re-shape the data to contain exactly the five columns ‘event_time’, ‘uid’, ‘status_code’, ‘message’, and ‘ok’.
Aliases¶
colpick
(deprecated)