Aggregate
BigQuery
ARRAY_CONCAT_AGG
BigQueryConcatenates multiple arrays into a single array. Useful when each row already contains an array and you want to merge them all into one.
Tipe hasil:
ARRAY<T>Diperbarui: 13 Jun 2026Syntax
SQL
ARRAY_CONCAT_AGG(expression [ORDER BY key])Parameter
expressionARRAYwajib
An array column to concatenate
ORDER BYclauseopsional
Sort arrays before concatenating
Contoh Penggunaan
Concatenate Tag Arrays
SQL
1 SELECT 2 category, 3 ARRAY_CONCAT_AGG(tags) as all_tags 4 FROM `project.dataset.products` 5 GROUP BY category;
Merges all tags from products within the same category.
Hasil
| category | all_tags |
|---|---|
| Electronics | ["gadget", "tech", "smart", "portable"] |
| Fashion | ["style", "trend", "casual", "formal"] |
ARRAY_CONCAT_AGG with ORDER BY
SQL
1 SELECT 2 user_id, 3 ARRAY_CONCAT_AGG(daily_activities ORDER BY activity_date) as all_activities 4 FROM `project.dataset.user_logs` 5 GROUP BY user_id;
Merges daily activities per user in chronological order.
Hasil
| user_id | all_activities |
|---|---|
| U001 | ["login", "view", "purchase", "logout", ...] |
Flatten Nested Arrays
SQL
1 SELECT 2 store_id, 3 ARRAY_CONCAT_AGG(product_ids) as all_product_ids, 4 ARRAY_LENGTH(ARRAY_CONCAT_AGG(product_ids)) as total_products 5 FROM `project.dataset.store_inventory` 6 GROUP BY store_id;
Merges all product IDs from multiple shipments.
Hasil
| store_id | all_product_ids | total_products |
|---|---|---|
| S001 | [101, 102, 201, 202] | 4 |
| S002 | [101, 301, 302, 303] | 4 |
Pertanyaan Umum tentang ARRAY_CONCAT_AGG
Apa itu fungsi ARRAY_CONCAT_AGG di BigQuery?
Concatenates multiple arrays into a single array. Useful when each row already contains an array and you want to merge them all into one. Di BigQuery, fungsi ARRAY_CONCAT_AGG termasuk dalam kelompok fungsi yang sering digunakan untuk mengolah dan menganalisis data secara efisien.
Bagaimana cara menggunakan ARRAY_CONCAT_AGG di BigQuery?
Gunakan sintaks berikut: ARRAY_CONCAT_AGG(expression [ORDER BY key]). Pastikan argumen yang dimasukkan sudah sesuai dengan tipe data yang diharapkan.
Apa nilai yang dikembalikan oleh fungsi ARRAY_CONCAT_AGG?
Fungsi ARRAY_CONCAT_AGG mengembalikan nilai bertipe ARRAY<T>. Pastikan tipe data hasil sudah sesuai dengan kebutuhan query atau formula kamu. Jika input mengandung nilai NULL, perilaku fungsi dapat berbeda — selalu periksa dokumentasi untuk memastikan hasilnya sesuai ekspektasi.
Apa saja parameter fungsi ARRAY_CONCAT_AGG?
Fungsi ini memiliki 1 parameter wajib dan 1 parameter opsional. Parameter yang digunakan: expression (ARRAY, wajib): An array column to concatenate; ORDER BY (clause, opsional): Sort arrays before concatenating.
Ngulik Langsung
Latihan Langsung →Sudah paham ARRAY_CONCAT_AGG? Latih langsung di browser
Latihan interaktif, langsung di browser.