String

FARM_FINGERPRINT

BigQuery

Menghitung fingerprint menggunakan algoritma FarmHash. Sangat cepat dan cocok untuk BigQuery.

Tipe hasil: INT64

Syntax

SQL

FARM_FINGERPRINT(value)

valueSTRING/BYTESwajib

Nilai yang akan di-fingerprint

SQL

1 SELECT FARM_FINGERPRINT('hello') AS fp;

FarmHash fingerprint dari 'hello'.

Hasil

fp: -7082577908326661994

SQL

1 SELECT *
2 FROM users
3 WHERE MOD(FARM_FINGERPRINT(user_id), 100) < 10;

Sample 10% data secara deterministik.

Hasil

(10% sample of users)

SQL

1 SELECT
2   MOD(ABS(FARM_FINGERPRINT(CAST(user_id AS STRING))), 10) AS partition_num,
3   COUNT(*)
4 FROM events
5 GROUP BY partition_num;

Distribute data ke 10 partisi.

Hasil

(partition distribution)

1	SELECT *
2	FROM users
3	WHERE MOD(FARM_FINGERPRINT(user_id), 100) < 10;

1	SELECT
2	MOD(ABS(FARM_FINGERPRINT(CAST(user_id AS STRING))), 10) AS partition_num,
3	COUNT(*)
4	FROM events
5	GROUP BY partition_num;