Tabular operators

Join operator

Render operator

Summarize operator

as operator

Learn how to use the as operator to bind a name to the operator’s input tabular expression.

consume operator

Learn how to use the consume operator to consume the tabular data stream handed to the operator.

count operator

Learn how to use the count operator to return the number of records in the input record set.

datatable operator

Learn how to use the datatable operator to define a table with given schema and data.

distinct operator

Learn how to use the distinct operator to create a table with the distinct combination of the columns of the input table.

evaluate plugin operator

Learn how to use the evaluate plugin operator to invoke plugins.

extend operator

Learn how to use the extend operator to create calculated columns and append them to the result set.

externaldata operator

Learn how to use the externaldata operator to return a data table of the given schema whose data was parsed from the specified storage artifact.

facet operator

Learn how to use the facet operator to return a table for each specified column.

find operator

Learn how to use the find operator to find rows that match a predicate across a set of tables.

fork operator

Learn how to use the fork operator to run multiple consumer operators in parallel.

getschema operator

Learn how to use the getschema operator to create a tabular schema of the input.

invoke operator

Learn how to use the invoke operator to invoke a lambda expression that receives the source of invoke as a tabular parameter argument

lookup operator

Learn how to use the lookup operator to extend columns of a fact table.

mv-apply operator

Learn how to use the mv-apply operator to apply a subquery to each record and union the results of each subquery.

mv-expand operator

Learn how to use the mv-expand operator to expand multi-value dynamic arrays or property bags into multiple records.

parse operator

Learn how to use the parse operator to parse the value of a string expression into one or more calculated columns.

parse-kv operator

Learn how to use the parse-kv operator to represent structured information extracted from a string expression in a key/value form.

parse-where operator

Learn how to use the parse-where operator to parse the value of a string expression into one or more calculated columns.

partition operator

Learn how to use the partition operator to partition the records of the input table into multiple subtables.

print operator

Learn how to use the print operator to output a single row with one or more scalar expression results as columns.

Project operator

Learn how to use the project operator to select columns to include, rename or drop, and to insert new computed columns in the output table.

project-away operator

Learn how to use the project-away operator to select columns from the input table to exclude from the output table.

project-keep operator

Learn how to use the project-keep operator to select columns from the input to keep in the output.

project-rename operator

Learn how to use the project-rename operator to rename columns in the output table.

project-reorder operator

Learn how to use the project-reorder operator to reorder columns in the output table.

Queries

Learn how to use queries to explore and process data in the context of databases.

range operator

Learn how to use the range operator to generate a single-column table of values.

reduce operator

Learn how to use the reduce operator to group a set of strings together based on value similarity.

sample operator

Learn how to use the sample operator to return up to the specified number of rows from the input table.

sample-distinct operator

Learn how to use the sample-distinct operator to return a column that contains up to the specified number of distinct values of the requested columns.

scan operator

Learn how to use the scan operator to scan data, match, and build sequences based on the predicates.

search operator

Learn how to use the search operator to search for a text pattern in multiple tables and columns.

serialize operator

Learn how to use the serialize operator to mark the input row set as serialized and ready for window functions.

Shuffle query

This article describes Shuffle query.

sort operator

Learn how to use the sort operator to sort the rows of the input table by one or more columns.

take operator

Learn how to use the take operator to return a specified number of rows.

top operator

Learn how to use the top operator to return the first specified number of records sorted by the specified column.

top-hitters operator

Learn how to use the top-hitters operator to return an approximation for the most popular distinct values in the input.

top-nested operator

Learn how to use the top-nested operator to produce a hierarchical aggregation.

union operator

This article describes union operator.

where operator

Learn how to use the where operator to filter a table to the subset of rows that satisfy a predicate.