xxhash

SELECT *,xxhash64(CAST(shop_nm AS varbinary)) ,from_big_endian_64(xxhash64(CAST(shop_nm AS varbinary))) FROM db_ads.ads_merchandise_dim_shop ......