org.apache.calcite.rel.rules.AggregateReduceFunctionsRule * * <li>AVG(x) → SUM(x) / COUNT(x) * * <li>STDDEV_POP(x) → SQRT( * (SUM(x * x) - SUM(x) * SUM(x) / COUNT(x)) * / COUNT(x)) * * <li>STDDEV_SAMP(x) → SQRT( * (SUM(x * x) - SUM(x) * SUM(x) / COUNT(x)) * / CASE COUNT(x) WHEN 1 THEN NULL ELSE COUNT(x) - 1 END) * * <li>VAR_POP(x) → (SUM(x * x) - SUM(x) * SUM(x) / COUNT(x)) * / COUNT(x) * * <li>VAR_SAMP(x) → (SUM(x * x) - SUM(x) * SUM(x) / COUNT(x)) * / CASE COUNT(x) WHEN 1 THEN NULL ELSE COUNT(x) - 1 END * * <li>COVAR_POP(x, y) → (SUM(x * y) - SUM(x, y) * SUM(y, x) * / REGR_COUNT(x, y)) / REGR_COUNT(x, y) * * <li>COVAR_SAMP(x, y) → (SUM(x * y) - SUM(x, y) * SUM(y, x) / REGR_COUNT(x, y)) * / CASE REGR_COUNT(x, y) WHEN 1 THEN NULL ELSE REGR_COUNT(x, y) - 1 END * * <li>REGR_SXX(x, y) → REGR_COUNT(x, y) * VAR_POP(y) * * <li>REGR_SYY(x, y) → REGR_COUNT(x, y) * VAR_POP(x)
[Apache Calcite]reduce avg AggregateReduceFunctionsRule
最新推荐文章于 2021-11-19 14:02:43 发布