ydb/yql/essentials/udfs/common/digest/test/cases/Basic.sql

/* syntax version 1 */
SELECT
    Digest::Crc32c(key) AS crc32c,
    Digest::Crc64(key) AS crc64,
    Digest::Fnv32(key) AS fnv32,
    Digest::Fnv64(key) AS fnv64,
    Digest::MurMurHash(key) AS murmur,
    Digest::MurMurHash32(key) AS murmur32,
    Digest::MurMurHash2A(key) AS murmur2a,
    Digest::MurMurHash2A32(key) AS murmur2a32,
    Digest::CityHash(key) AS city,
    Digest::CityHash(key, 111) AS cityWithSeed,
    Digest::CityHash128(key) AS city128,
    Digest::NumericHash(COALESCE(CAST(key AS Uint64), 0)) AS numeric,
    Digest::Md5Hex(key) AS md5hex,
    Digest::Md5Raw(key) AS md5raw,
    Digest::Md5HalfMix(key) AS md5halfmix,
    Digest::Argon2(key, "12345678") AS argon2,
    Digest::Blake2B(key) AS blake2b,
    Digest::Blake2B(key, "") AS blake2bunkeyed,
    Digest::Blake2B(key, "12345678") AS blake2bkeyed,
    Digest::SipHash(111, 222, key) AS sip,
    Digest::HighwayHash(111, 222, 333, 444, key) AS highway,
    Digest::FarmHashFingerprint(COALESCE(CAST(key AS Uint64), 0u)) AS farmfing,
    Digest::FarmHashFingerprint2(123ul, CAST(key AS Uint64)) AS farmfing2,
    Digest::FarmHashFingerprint32(key) AS farmfing32,
    Digest::FarmHashFingerprint64(key) AS farmfing64,
    Digest::FarmHashFingerprint128(key) AS farmfing128,
    Digest::SuperFastHash(key) AS sfh,
    Digest::Sha1(key) as sha1,
    Digest::Sha256(key) as sha256,
    Digest::IntHash64(COALESCE(CAST(key AS Uint64), 0)) AS inthash64,
    Digest::XXH3(key) AS xxhash,
    Digest::XXH3_128(key) AS xxhash128
FROM Input;