SKEW,SKEW_POP,SKEWNESS
skewness,skew,skew_pop
Description
Returns the skewness of the expr expression.
The forumula used for this function is 3-th centrol moment / ((variance)^{1.5})
, when variance is zero, skewness
will return NULL
.
Syntax
skewness(expr)
Arguments
TinyInt/SmallInt/Integer/BigInt/Float/Double, Decimal will be casted to a float number.
Return value
Double
Example
create table statistic_test (tag int, val1 double not null, val2 double null)
distributed by hash(tag) properties("replication_num"="1")
insert into statistic_test values (1, -10, -10),
(2, -20, NULL),
(3, 100, NULL),
(4, 100, NULL),
(5, 1000,1000);
// NULL is ignored
select skew(val1), skew(val2) from statistic_test
--------------
+--------------------+--------------------+
| skew(val1) | skew(val2) |
+--------------------+--------------------+
| 1.4337199628825619 | 1.1543940205711711 |
+--------------------+--------------------+
1 row in set (0.01 sec)
// Each group just has one row, result is NULL
select skew(val1), skew(val2) from statistic_test group by tag
--------------
+------------+------------+
| skew(val1) | skew(val2) |
+------------+------------+
| NULL | NULL |
| NULL | NULL |
| NULL | NULL |
| NULL | NULL |
| NULL | NULL |
+------------+------------+
5 rows in set (0.04 sec)