散列函数

本页按功能分类，全面概述 TiDB Cloud Lake 中的散列函数，便于快速查阅。

加密散列函数

非加密散列函数

使用示例

数据完整性验证

-- Calculate MD5 hash for file content verification
SELECT
  filename,
  MD5(file_content) AS content_hash
FROM files
ORDER BY filename;

数据匿名化

-- Hash sensitive data before storing or processing
SELECT
  user_id,
  SHA2(email, 256) AS hashed_email,
  SHA2(phone_number, 256) AS hashed_phone
FROM users;

基于散列的分区

-- Use hash functions for data distribution
SELECT
  XXHASH64(customer_id) % 10 AS partition_id,
  COUNT(*) AS records_count
FROM orders
GROUP BY partition_id;