MULTI_DISTINCT_COUNT (Lakehouse v2)
返回不同值的个数,等同于 COUNT(DISTINCT)。
Analyze 语法
Section titled “Analyze 语法”func.multi_distinct_count(get_column(table, 'dept'))Analyze 示例
Section titled “Analyze 示例”func.multi_distinct_count(get_column(table, 'department'))
┌───┐│ 5 │└───┘SQL 语法
Section titled “SQL 语法”MULTI_DISTINCT_COUNT(<dept>)SQL 示例
Section titled “SQL 示例”SELECT MULTI_DISTINCT_COUNT(department) FROM employees;
┌───┐│ 5 │└───┘