Math

LOG

BigQuery

Menghitung logaritma dengan basis yang dapat ditentukan.

Tipe hasil: FLOAT64Diperbarui: 7 Jan 2026

Syntax

SQL

LOG(expression [, base])

expressionFLOAT64/INT64wajib

Angka positif

baseFLOAT64/INT64opsional

Basis logaritma (default: e untuk natural log)

SQL

1 SELECT
2   LOG(100, 10) as log_base_10,
3   LOG(8, 2) as log_base_2,
4   LOG(EXP(1)) as natural_log;

Logaritma dengan berbagai basis.

Hasil

log_base_10	log_base_2	natural_log
2.0	3.0	1.0

SQL

1 SELECT
2   number,
3   CEIL(LOG(number, 2)) as bits_needed
4 FROM UNNEST([1, 7, 8, 255, 256]) as number;

Menghitung jumlah bit yang diperlukan.

1	SELECT
2	number,
3	CEIL(LOG(number, 2)) as bits_needed
4	FROM UNNEST([1, 7, 8, 255, 256]) as number;