Hash functions

Stay organized with collections Save and categorize content based on your preferences.

FARM_FINGERPRINT(value) 

WITH example AS (   SELECT 1 AS x, "foo" AS y, true AS z UNION ALL   SELECT 2 AS x, "apple" AS y, false AS z UNION ALL   SELECT 3 AS x, "" AS y, true AS z ) SELECT   *,   FARM_FINGERPRINT(CONCAT(CAST(x AS STRING), y, CAST(z AS STRING)))     AS row_fingerprint FROM example; /*---+-------+-------+----------------------*  | x | y     | z     | row_fingerprint      |  +---+-------+-------+----------------------+  | 1 | foo   | true  | -1541654101129638711 |  | 2 | apple | false | 2794438866806483259  |  | 3 |       | true  | -4880158226897771312 |  *---+-------+-------+----------------------*/ 

MD5(input) 

SELECT MD5("Hello World") as md5;  -- Note that the result of MD5 is of type BYTES, displayed as a base64-encoded string. /*--------------------------*  | md5                      |  +--------------------------+  | sQqNsWTgdUEFt6mb5y4/5Q== |  *--------------------------*/ 

SHA1(input) 

SELECT SHA1("Hello World") as sha1;  -- Note that the result of SHA1 is of type BYTES, displayed as a base64-encoded string. /*------------------------------*  | sha1                         |  +------------------------------+  | Ck1VqNd45QIvq3AZd8XYQLvEhtA= |  *------------------------------*/ 

SHA256(input) 

SELECT SHA256("Hello World") as sha256; 

SHA512(input) 

SELECT SHA512("Hello World") as sha512;