make_set() (aggregation function)

  • Artikel

dynamic Membuat array dari kumpulan nilai berbeda yang diambil expr dalam grup.

Nilai null diabaikan dan tidak memperhitungkan perhitungan.

Catatan

Fungsi ini digunakan bersama dengan ringkasan operator.

Alias yang tidak digunakan lagi: makeset()

Sintaks

make_set(expr [,maxSize])

Pelajari selengkapnya tentang konvensi sintaksis.

Parameter

Nama Jenis Diperlukan Deskripsi
expr string ✔️ Ekspresi yang digunakan untuk perhitungan agregasi.
maxSize int Jumlah maksimum elemen yang dikembalikan. Nilai default dan maks adalah 1048576.

Catatan

Versi yang tidak digunakan lagi memiliki batas maxSize default 128.

Mengembalikan

Mengembalikan dynamic array dari kumpulan nilai berbeda yang diambil expr dalam grup. Urutan sortir larik tidak ditentukan.

Tip

Untuk hanya menghitung nilai yang berbeda, gunakan dcount() atau count_distinct().

Contoh

Mengatur dari kolom skalar

Contoh berikut menunjukkan kumpulan status yang dikelompokkan dengan jumlah kerusakan pemangkasan yang sama.

Menjalankan kueri

StormEvents 
| summarize states=make_set(State) by DamageCrops

Tabel hasil yang ditampilkan hanya menyertakan 10 baris pertama.

DamageCrops status
0 ["NORTH CAROLINA","WISCONSIN","NEW YORK","ALASKA","DELAWARE","OKLAHOMA","INDIANA","ILLINOIS","MINNESOTA","SOUTH DAKOTA","TEXAS","UTAH","COLORADO","VERMONT","NEW JERSEY","VIRGINIA","CALIFORNIA","PENNSYLVANIA","MONTANA","WASHINGTON",""CALIFORNIA","PENNSYLVANIA","MONTANA","WASHINGTON","". OREGON","HAWAII","IDAHO","PUERTO RICO","MICHIGAN","FLORIDA","WYOMING","TELUK MEKSIKO","NEVADA","LOUISIANA ","TENNESSEE","KENTUCKY","MISSISSIPPI","ALABAMA","GEORGIA","SOUTH CAROLINA","OHIO","NEW MEXICO","ATLANTIC SOUTH","NEW CAROLINA","NEW HAMPSHIRE","ATLANTIC NORTH","NORTH DAKOTA","IOWA","NEBRASKA","WEST VIRGINIA","MARYLAND","KANSAS","MISSOURI","ARKANSAS","ARIZONA","MASSACHUSETTS","MAINE","CONNECTICUT","GU ","HAWAII WATERS","AMERICAN SAMOA","LAKE HURON","DISTRICT OF COLUMBIA","RHODE ISLAND","LAKE MICHIGAN","LAKE SUPERIOR","LAKE ST CLAIR","LAKE ERIE","LAKE ONTARIO","E PACIFIC","TELUK ALASKA"]
30000 ["TEXAS","NEBRASKA","IOWA","MINNESOTA","WISCONSIN"]
4000000 ["CALIFORNIA","KENTUCKY","NORTH DAKOTA","WISCONSIN","VIRGINIA"]
3000000 ["CALIFORNIA","ILLINOIS","MISSOURI","SOUTH CAROLINA","NORTH CAROLINA","MISSISSIPPI","NORTH DAKOTA","OHIO"]
14000000 ["CALIFORNIA","NORTH DAKOTA"]
400000 ["CALIFORNIA","MISSOURI","MISSISSIPPI","NEBRASKA","WISCONSIN","NORTH DAKOTA"]
50000 ["CALIFORNIA","GEORGIA","NEBRASKA","TEXAS","WEST VIRGINIA","KANSAS","MISSOURI","MISSISSIPPI","NEW MEXICO","IOWA","NORTH DAKOTA","OHIO","WISCONSIN","ILLINOIS","MINNESOTA","KENTUCKY"]
18000 ["WASHINGTON","WISCONSIN"]
107900000 ["CALIFORNIA"]
28900000 ["CALIFORNIA"]

Mengatur dari kolom array

Contoh berikut menunjukkan kumpulan elemen dalam array.

Menjalankan kueri

datatable (Val: int, Arr1: dynamic)
[
    1, dynamic(['A1', 'A2', 'A3']), 
    5, dynamic(['A2', 'C1']),
    7, dynamic(['C2', 'A3']),
    5, dynamic(['C2', 'A1'])
] 
| summarize Val_set=make_set(Val), Arr1_set=make_set(Arr1)
Val_set Arr1_set
[1,5,7] ["A1","A2","A3","C1","C2"]

Konten terkait

  • Gunakan operator mv-expand untuk fungsi yang berlawanan.
  • Operator make_set_if mirip dengan make_set, kecuali operator tersebut juga menerima predikat.