Skip to main content
Skip to main content

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)

kurt