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
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
|
/* syntax version 1 */
/* postgres can not */
$t = SELECT * FROM AS_TABLE([<|key: 1, value: 2|>,<|key: 1, value: 3|>]);
$p =
SELECT
key,percentile(value, 0.1) as a
FROM $t
GROUP BY
key
with combine
;
$p = PROCESS $p;
--select FormatType(TypeOf($p));
select * from $p;
$p = SELECT
key,percentile(a, 0.1) as a
FROM $p
GROUP BY
key
with combinestate
;
$p = PROCESS $p;
--select FormatType(TypeOf($p));
select * from $p;
$p = SELECT
key,percentile(a, 0.1) as a
FROM $p
GROUP BY
key
with mergestate
;
$p = PROCESS $p;
--select FormatType(TypeOf($p));
select * from $p;
$p1 = SELECT
key,percentile(a, 0.1) as a
FROM $p
GROUP BY
key
with mergefinalize
;
$p1 = PROCESS $p1;
--select FormatType(TypeOf($p1));
select * from $p1;
$p2 = SELECT
key,percentile(a, 0.1) as a
FROM (select key, just(a) as a from $p)
GROUP BY
key
with mergemanyfinalize
;
$p2 = PROCESS $p2;
--select FormatType(TypeOf($p2));
select * from $p2;
$p3 =
SELECT
key,percentile(value, 0.1) as a
FROM $t
GROUP BY
key
with finalize
;
$p3 = PROCESS $p3;
--select FormatType(TypeOf($p));
select * from $p3;
|
