corr
corr介绍
corr(expr1, expr2) - 返回一组数字对之间的皮尔逊相关系数。
Examples:
> SELECT corr(c1, c2) FROM VALUES (3, 2), (3, 3), (6, 4) as tab(c1, c2);
0.8660254037844387
Since: 1.6.0
corr(expr1, expr2) - 返回一组数字对之间的皮尔逊相关系数。
Examples:
> SELECT corr(c1, c2) FROM VALUES (3, 2), (3, 3), (6, 4) as tab(c1, c2);
0.8660254037844387
Since: 1.6.0