lookup¶

Type of operation: Join

Description¶

Find matching rows in a resource, making new columns in the output dataset. The lookup verb looks for a sequence of one or more [email protected] expressions. Together these make up the join predicate, which defines what to look up by. The remaining arguments should be of the form name:@other.value, which define what values to retrieve.

Usage¶

lookup foreignkeyequalitypredicate ..., columnbinding ...


Argument

Type

Required

Multiple

foreignkeyequalitypredicate

bool

Required

Can be multiple

columnbinding

expression

Required

Can be multiple

Accelerable¶

lookup 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¶

lookup [email protected], [email protected], hostname:@host.name, hostip:@host.ip


Using the values for ‘host_uid’ and ‘host_cluster’, look up the rows matching the same ‘uid’ and ‘cluster’ values in the input table named ‘host’. Extract the ‘name’ and ‘ip’ values from those ‘host’ dataset rows, using them populate new columns in the output called ‘hostname’ and ‘hostip’.