天天看點

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
           

繼續閱讀