الملاحظات تحرير

distinct operator

  • مقالة
  • قراءة خلال 2 دقائق

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 *

Example

Shows the distinct combination of fruit and price.

Table | distinct fruit, price

Two tables. One has suppliers, fruit types, and prices, with some fruit-price combinations repeated. The second table lists only unique combinations.

Notes

  • Unlike summarize by ..., the distinct operator 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.