HLL_RAW_AGG(Lakehouse v2)
複数のHLL値を1つのHLL値に集計します。
Analyzeの構文
Section titled “Analyzeの構文”func.hll_raw_agg(get_column(table, 'hll_col'))Analyzeの例
Section titled “Analyzeの例”func.hll_raw_agg(get_column(table, 'hll_col'))
┌─────────────┐│ (hll value) │└─────────────┘SQLの構文
Section titled “SQLの構文”HLL_RAW_AGG(<hll_col>)SELECT HLL_CARDINALITY(HLL_RAW_AGG(hll_col)) FROM sketches;
┌──────┐│ 5000 │└──────┘