VARIANCE (Lakehouse v2)
返回总体方差,是 VARIANCE_POP 的别名。
Analyze 语法
Section titled “Analyze 语法”func.variance(get_column(table, 'score'))Analyze 示例
Section titled “Analyze 示例”func.variance(get_column(table, 'score'))
┌────────┐│ 234.72 │└────────┘SQL 语法
Section titled “SQL 语法”VARIANCE(<score>)SQL 示例
Section titled “SQL 示例”SELECT VARIANCE(score) FROM test_results;
┌────────┐│ 234.72 │└────────┘