1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
|
# name: test/sql/function/list/aggregates/skewness.test
# description: Test the list_skewness aggregate function
# group: [aggregates]
# incorrect usage
statement error
select list_skewness()
----
query I
select list_skewness([1])
----
NULL
statement ok
CREATE TABLE skew AS SELECT LIST(10) AS i FROM range(5) t1(i)
# constant value
query I
select list_skewness (i) from skew
----
NAN
query I
select list_skewness ([1,2])
----
NULL
# out of range
statement error
select list_skewness([-2e307, 0, 2e307])
----
statement ok
create table aggr(k int[], v decimal(10,2)[], v2 decimal(10, 2)[]);
statement ok
insert into aggr values ([1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2],
[10, 10, 10, 10, 20, 20, 25, 30, 30, 30, 30],
[NULL, 11, 15, 18, 22, 25, NULL, 35, 40, 50, 51]),
([], NULL, [NULL]);
query III
select list_skewness(k), list_skewness(v), list_skewness(v2) from aggr
----
-3.316625 -0.163444 0.365401
NULL NULL NULL
statement ok
create table aggr2(v2 decimal(10, 2)[]);
statement ok
insert into aggr2 values ([NULL, 11, 15, 18]), ([22, 25]), ([NULL]), ([35, 40, 50, 51]);
query I
select list_skewness(v2) from aggr2
----
-0.423273
NULL
NULL
-0.330141
|
