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
|
# name: benchmark/micro/aggregate/dictionary_aggregate.benchmark
# description: Aggregate Over Dictionary Vectors
# group: [aggregate]
name Aggregate Over Dictionary Vectors
group aggregate
storage persistent
load
CREATE TABLE t AS SELECT CONCAT('thisisastringwithrepetitions', i%100) AS grp, i FROM range(100_000_000) tbl(i);
run
SELECT grp, SUM(i) FROM t GROUP BY ALL ORDER BY ALL
result II
thisisastringwithrepetitions0 49999950000000
thisisastringwithrepetitions1 49999951000000
thisisastringwithrepetitions10 49999960000000
thisisastringwithrepetitions11 49999961000000
thisisastringwithrepetitions12 49999962000000
thisisastringwithrepetitions13 49999963000000
thisisastringwithrepetitions14 49999964000000
thisisastringwithrepetitions15 49999965000000
thisisastringwithrepetitions16 49999966000000
thisisastringwithrepetitions17 49999967000000
thisisastringwithrepetitions18 49999968000000
thisisastringwithrepetitions19 49999969000000
thisisastringwithrepetitions2 49999952000000
thisisastringwithrepetitions20 49999970000000
thisisastringwithrepetitions21 49999971000000
thisisastringwithrepetitions22 49999972000000
thisisastringwithrepetitions23 49999973000000
thisisastringwithrepetitions24 49999974000000
thisisastringwithrepetitions25 49999975000000
thisisastringwithrepetitions26 49999976000000
thisisastringwithrepetitions27 49999977000000
thisisastringwithrepetitions28 49999978000000
thisisastringwithrepetitions29 49999979000000
thisisastringwithrepetitions3 49999953000000
thisisastringwithrepetitions30 49999980000000
thisisastringwithrepetitions31 49999981000000
thisisastringwithrepetitions32 49999982000000
thisisastringwithrepetitions33 49999983000000
thisisastringwithrepetitions34 49999984000000
thisisastringwithrepetitions35 49999985000000
thisisastringwithrepetitions36 49999986000000
thisisastringwithrepetitions37 49999987000000
thisisastringwithrepetitions38 49999988000000
thisisastringwithrepetitions39 49999989000000
thisisastringwithrepetitions4 49999954000000
thisisastringwithrepetitions40 49999990000000
thisisastringwithrepetitions41 49999991000000
thisisastringwithrepetitions42 49999992000000
thisisastringwithrepetitions43 49999993000000
thisisastringwithrepetitions44 49999994000000
thisisastringwithrepetitions45 49999995000000
thisisastringwithrepetitions46 49999996000000
thisisastringwithrepetitions47 49999997000000
thisisastringwithrepetitions48 49999998000000
thisisastringwithrepetitions49 49999999000000
thisisastringwithrepetitions5 49999955000000
thisisastringwithrepetitions50 50000000000000
thisisastringwithrepetitions51 50000001000000
thisisastringwithrepetitions52 50000002000000
thisisastringwithrepetitions53 50000003000000
thisisastringwithrepetitions54 50000004000000
thisisastringwithrepetitions55 50000005000000
thisisastringwithrepetitions56 50000006000000
thisisastringwithrepetitions57 50000007000000
thisisastringwithrepetitions58 50000008000000
thisisastringwithrepetitions59 50000009000000
thisisastringwithrepetitions6 49999956000000
thisisastringwithrepetitions60 50000010000000
thisisastringwithrepetitions61 50000011000000
thisisastringwithrepetitions62 50000012000000
thisisastringwithrepetitions63 50000013000000
thisisastringwithrepetitions64 50000014000000
thisisastringwithrepetitions65 50000015000000
thisisastringwithrepetitions66 50000016000000
thisisastringwithrepetitions67 50000017000000
thisisastringwithrepetitions68 50000018000000
thisisastringwithrepetitions69 50000019000000
thisisastringwithrepetitions7 49999957000000
thisisastringwithrepetitions70 50000020000000
thisisastringwithrepetitions71 50000021000000
thisisastringwithrepetitions72 50000022000000
thisisastringwithrepetitions73 50000023000000
thisisastringwithrepetitions74 50000024000000
thisisastringwithrepetitions75 50000025000000
thisisastringwithrepetitions76 50000026000000
thisisastringwithrepetitions77 50000027000000
thisisastringwithrepetitions78 50000028000000
thisisastringwithrepetitions79 50000029000000
thisisastringwithrepetitions8 49999958000000
thisisastringwithrepetitions80 50000030000000
thisisastringwithrepetitions81 50000031000000
thisisastringwithrepetitions82 50000032000000
thisisastringwithrepetitions83 50000033000000
thisisastringwithrepetitions84 50000034000000
thisisastringwithrepetitions85 50000035000000
thisisastringwithrepetitions86 50000036000000
thisisastringwithrepetitions87 50000037000000
thisisastringwithrepetitions88 50000038000000
thisisastringwithrepetitions89 50000039000000
thisisastringwithrepetitions9 49999959000000
thisisastringwithrepetitions90 50000040000000
thisisastringwithrepetitions91 50000041000000
thisisastringwithrepetitions92 50000042000000
thisisastringwithrepetitions93 50000043000000
thisisastringwithrepetitions94 50000044000000
thisisastringwithrepetitions95 50000045000000
thisisastringwithrepetitions96 50000046000000
thisisastringwithrepetitions97 50000047000000
thisisastringwithrepetitions98 50000048000000
thisisastringwithrepetitions99 50000049000000
|
