Produces a table with the distinct combination of the provided columns of the input table.
T | distinct Column1, Column2
Produces a table with the distinct combination of all columns in the input table.
T | distinct *
Shows the distinct combination of fruit and price.
Table | distinct fruit, price
summarize by ..., the
distinctoperator supports providing an asterisk (
*) as the group key, making it easier to use for wide tables.
- If the group by keys are of high cardinalities, using
summarize by ...with the shuffle strategy could be useful.