Aggregate

BIT_OR

BigQueryBigQuery

Performs a bitwise OR operation across all values in a group. Returns a value where each bit is 1 if at least one input value has that bit set to 1.

Tipe hasil: INT64Diperbarui: 13 Jun 2026

Syntax

SQL
BIT_OR(expression)

Parameter

expressionINT64wajib

The integer column or expression to OR together

Contoh Penggunaan

Any Permission in Group

SQL
1SELECT
2  user_group,
3  BIT_OR(permissions) as any_permissions
4FROM `project.dataset.user_permissions`
5GROUP BY user_group;

Finds all permissions held by AT LEAST ONE user in each group.

Hasil
user_groupany_permissions
admin255
editor127
viewer31

Combined Feature Flags

SQL
1SELECT
2  country,
3  BIT_OR(enabled_features) as available_features,
4  BIN(BIT_OR(enabled_features)) as binary_view
5FROM `project.dataset.regional_features`
6GROUP BY country;

Views all features available in a given country.

Hasil
countryavailable_featuresbinary_view
Indonesia1271111111
Singapore25511111111
Malaysia63111111

Error Types Encountered

SQL
1SELECT
2  service_name,
3  BIT_OR(error_type_flags) as error_types_seen
4FROM `project.dataset.error_logs`
5WHERE DATE(timestamp) >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
6GROUP BY service_name;

Identifies all error types that have occurred per service.

Hasil
service_nameerror_types_seen
auth-service7
api-gateway15
database3

Pertanyaan Umum tentang BIT_OR

Apa itu fungsi BIT_OR di BigQuery?
Performs a bitwise OR operation across all values in a group. Returns a value where each bit is 1 if at least one input value has that bit set to 1. Di BigQuery, fungsi BIT_OR termasuk dalam kelompok fungsi yang sering digunakan untuk mengolah dan menganalisis data secara efisien.
Bagaimana cara menggunakan BIT_OR di BigQuery?
Gunakan sintaks berikut: BIT_OR(expression). Pastikan argumen yang dimasukkan sudah sesuai dengan tipe data yang diharapkan.
Apa nilai yang dikembalikan oleh fungsi BIT_OR?
Fungsi BIT_OR mengembalikan nilai bertipe INT64. 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 BIT_OR?
Fungsi ini memiliki 1 parameter wajib. Parameter yang digunakan: expression (INT64, wajib): The integer column or expression to OR together.

Fungsi Terkait

BIT_ANDBIT_XOR
Ngulik Langsung

Sudah paham BIT_OR? Latih langsung di browser

Latihan interaktif, langsung di browser.

Latihan Langsung →
Kembali ke BigQuery Functions