Hash functions

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;