DS_HLL_COMBINE(Lakehouse v2)
複数のDataSketches HLLスケッチを1つのスケッチに結合します。
Analyzeの構文
Section titled “Analyzeの構文”func.ds_hll_combine(get_column(table, 'hll_sketch'))Analyzeの例
Section titled “Analyzeの例”func.ds_hll_combine(get_column(table, 'hll_sketch'))
┌───────────────────┐│ (combined sketch) │└───────────────────┘SQLの構文
Section titled “SQLの構文”DS_HLL_COMBINE(<sketch_column>)SELECT DS_HLL_ESTIMATE(DS_HLL_COMBINE(sketch_col)) FROM daily_sketches;
┌───────┐│ 25000 │└───────┘