Hive Sql中均值、方差、标准差、皮尔逊相关系数、偏度、峰度统计字段

SELECT mean(age) AS '均值', variance(age) AS '方差', stddev(age) AS '标准差', corr(age,yearsmarried) AS '两个指标的相关系数', skewness(age) AS 'skewness偏度', kurtosis(age) AS 'kurtosis峰度'
FROM table