DS_HLL_ACCUMULATE (Lakehouse v2)
将值累积到 DataSketches HLL 草图中,用于近似去重计数。
Analyze 语法
Section titled “Analyze 语法”func.ds_hll_accumulate(get_column(table, 'user_id'))Analyze 示例
Section titled “Analyze 示例”func.ds_hll_accumulate(get_column(table, 'user_id'))
┌──────────────┐│ (hll sketch) │└──────────────┘SQL 语法
Section titled “SQL 语法”DS_HLL_ACCUMULATE(<expr>)SQL 示例
Section titled “SQL 示例”SELECT DS_HLL_ESTIMATE(DS_HLL_ACCUMULATE(user_id)) FROM visits;
┌──────┐│ 9856 │└──────┘