forked from apache/doris
-
Notifications
You must be signed in to change notification settings - Fork 0
/
test_aggregate_all_functions2.out
120 lines (86 loc) · 2.07 KB
/
test_aggregate_all_functions2.out
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
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
-- This file is automatically generated. You should know what you did if you want to edit this
-- !select_approx_count_distinct1 --
2
-- !select_approx_count_distinct2 --
15
-- !select_collect_set1 --
5
-- !select_collect_set2 --
5
-- !select_collect_list1 --
5
-- !select_collect_list2 --
5
-- !select_histogram --
{"num_buckets":5,"buckets":[{"lower":"","upper":"jiw3n4","ndv":4,"count":4,"pre_sum":0},{"lower":"lifsno","upper":"wangjuoo5","ndv":3,"count":4,"pre_sum":4},{"lower":"wangynnsf","upper":"yanavnd","ndv":3,"count":4,"pre_sum":8},{"lower":"yanvjldjlll","upper":"yanvjldjlll","ndv":1,"count":1,"pre_sum":12},{"lower":"yunlj8@nk","upper":"yunlj8@nk","ndv":1,"count":2,"pre_sum":13}]}
-- !select_max_by1 --
15
-- !select_max_by2 --
8
-- !select_max_by3 --
3
-- !select_min_by1 --
2
-- !select_min_by2 --
7
-- !select_min_by3 --
1
-- !select_intersect_count_1 --
5
-- !select_intersect_count_2 --
5
-- !select_percentile_approx1 --
\N
-- !select_percentile_array --
[1985.1999999999998, 1989, 20456.999999999989]
-- !select_array_product --
\N
123.1230000000
1243.5000000000
24453.3250000000
243243.3250000000
243.3250000000
604587.0000000000
3.1410000000
-0.1230000000
-654.6540000000
-258.3690000000
0.6660000000
243.3250000000
100.0010000000
0E-10
0E-10
-- !select_quantile_percent --
8.0
-- !select_sum --
873327.585000000000000000
-- !select_topn_weighted1 --
[1991, 255, -32767]
-- !select_topn_weighted2 --
[1991, 255, -32767]
-- !select_topn_array1 --
["yunlj8@nk", "wangynnsf", "wangjuoo4"]
-- !select_topn_array2 --
["yunlj8@nk", "wangynnsf", "wangjuoo4"]
-- !select_topn_array3 --
[2015-04-02, 1991-08-11, 1989-03-21]
-- !select_topn_array4 --
[2015-04-02, 1991-08-11, 1989-03-21]
-- !select_topn_array5 --
[2015-04-02 00:00:00, 2015-03-13 12:36:38, 2013-04-02 15:16:52]
-- !select_topn_array6 --
[2015-04-02 00:00:00, 2015-03-13 12:36:38, 2013-04-02 15:16:52]
-- !select_count1 --
15
-- !select_count2 --
15
-- !select_minmax1 --
20200622 1 \N
20200622 2 \N
20200622 3 \N
-- !select_minmax2 --
20200622
-- !select_minmax3 --
287667876573
-- !select_minmax4 --
243