MULTI_DISTINCT_SUM (Lakehouse v2)
Returns the sum of distinct values.
Analyze Syntax
Section titled “Analyze Syntax”func.multi_distinct_sum(get_column(table, 'bonus'))Analyze Examples
Section titled “Analyze Examples”func.multi_distinct_sum(get_column(table, 'bonus'))
┌───────┐│ 25000 │└───────┘SQL Syntax
Section titled “SQL Syntax”MULTI_DISTINCT_SUM(<bonus>)SQL Examples
Section titled “SQL Examples”SELECT MULTI_DISTINCT_SUM(bonus) FROM employees;
┌───────┐│ 25000 │└───────┘