ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
SELECT count(*) FROM ks.tab WHERE token("store") > $min AND token("store") <= $max AND color = 'red' AND size = 'P' ALLOW FILTERING;
while read min max
2
do; echo "RANGE $min -- $max" ; time echo "SELECT count(*) FROM ks.tab WHERE token("store") > $min AND token("store") <= $max AND color = 'red' AND size = 'P' ALLOW FILTERING; " | cqlsh ; done < ranges
3
MinMaxRangeSizeDurationCount
4
-8.96E+18-8.70375E+182.60E+171.553918
5
-8.70E+18-8.44393E+182.60E+171.7374037
6
-8.44E+18-8.18412E+182.60E+171.853951
7
-8.18E+18-7.92431E+182.60E+171.9413952
8
-7.92E+18-7.66449E+182.60E+172.114007
9
-7.66E+18-7.40468E+182.60E+172.2914057
10
-7.40E+18-7.14487E+182.60E+172.3824097
11
-7.14E+18-6.88505E+182.60E+172.6743958
12
-6.89E+18-6.62524E+182.60E+172.7754068
13
-6.63E+18-6.36543E+182.60E+172.8794032
14
-6.37E+18-6.10561E+182.60E+173.1723851
15
-6.11E+18-5.8458E+182.60E+173.2223918
16
-5.85E+18-5.58599E+182.60E+173.3143959
17
-5.59E+18-5.32617E+182.60E+173.5813995
18
-5.33E+18-5.06636E+182.60E+173.7543880
19
-5.07E+18-4.80655E+182.60E+173.9024004
20
-4.81E+18-4.54673E+182.60E+173.9354040
21
-4.55E+18-4.28692E+182.60E+174.123915
22
-4.29E+18-4.02711E+182.60E+174.2794037
23
-4.03E+18-3.76729E+182.60E+174.4364117
24
-3.77E+18-3.50748E+182.60E+174.5414015
25
-3.51E+18-3.24767E+182.60E+174.6713998
26
-3.25E+18-2.98785E+182.60E+174.9313971
27
-2.99E+18-2.72804E+182.60E+175.0374023
28
-2.73E+18-2.46823E+182.60E+175.1874071
29
-2.47E+18-2.20841E+182.60E+175.484151
30
-2.21E+18-1.9486E+182.60E+175.4743929
31
-1.95E+18-1.68879E+182.60E+175.8023976
32
-1.69E+18-1.42897E+182.60E+175.814008
33
-1.43E+18-1.16916E+182.60E+176.0664024
34
-1.17E+18-9.09347E+172.60E+176.2363959
35
-9.09E+17-6.49533E+172.60E+176.2283947
36
-6.50E+17-3.8972E+172.60E+176.4634167
37
-3.90E+17-1.29907E+172.60E+176.574107
38
-1.30E+17
129906648406405292
2.60E+176.6594035
39
1.30E+17
389719945219215878
2.60E+176.913964
40
3.90E+17
649533242032026464
2.60E+176.9094014
41
6.50E+17
909346538844837050
2.60E+177.1973972
42
9.09E+17
1169159835657647637
2.60E+177.4793923
43
1.17E+18
1428973132470458223
2.60E+177.5283958
44
1.43E+18
1688786429283268809
2.60E+177.6274035
45
1.69E+18
1948599726096079395
2.60E+177.6743958
46
1.95E+18
2208413022908889981
2.60E+178.1324037
47
2.21E+18
2468226319721700567
2.60E+178.2023959
48
2.47E+18
2728039616534511153
2.60E+178.344090
49
2.73E+18
2987852913347321739
2.60E+178.5064036
50
2.99E+18
3247666210160132326
2.60E+178.7134171
51
3.25E+18
3507479506972942912
2.60E+178.774017
52
3.51E+18
3767292803785753498
2.60E+179.0824031
53
3.77E+18
4027106100598564084
2.60E+179.1083961
54
4.03E+18
4286919397411374670
2.60E+179.3614117
55
4.29E+18
4546732694224185256
2.60E+179.5814123
56
4.55E+18
4806545991036995842
2.60E+179.6494023
57
4.81E+18
5066359287849806428
2.60E+179.8614097
58
5.07E+18
5326172584662617015
2.60E+1710.1523970
59
5.33E+18
5585985881475427601
2.60E+1710.2814033
60
5.59E+18
5845799178288238187
2.60E+1710.3823954
61
5.85E+18
6105612475101048773
2.60E+1710.3463894
62
6.11E+18
6365425771913859359
2.60E+1710.7944133
63
6.37E+18
6625239068726669945
2.60E+1710.7534073
64
6.63E+18
6885052365539480531
2.60E+1711.0364077
65
6.89E+18
7144865662352291117
2.60E+1711.2524077
66
7.14E+18
7404678959165101704
2.60E+17
<stdin>:2:ReadTimeout: code=1200 [Coordinator node timed out waiting for replica nodes' responses] message="Operation timed out - received only 0 responses." info={'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'}
67
7.40E+18
7664492255977912290
2.60E+17
<stdin>:2:ReadTimeout: code=1200 [Coordinator node timed out waiting for replica nodes' responses] message="Operation timed out - received only 0 responses." info={'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'}
68
7.66E+18
7924305552790722876
2.60E+17
<stdin>:2:ReadTimeout: code=1200 [Coordinator node timed out waiting for replica nodes' responses] message="Operation timed out - received only 0 responses." info={'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'}
69
7.92E+18
8184118849603533462
2.60E+17
<stdin>:2:ReadTimeout: code=1200 [Coordinator node timed out waiting for replica nodes' responses] message="Operation timed out - received only 0 responses." info={'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'}
70
8.18E+18
8443932146416344048
2.60E+17
<stdin>:2:ReadTimeout: code=1200 [Coordinator node timed out waiting for replica nodes' responses] message="Operation timed out - received only 0 responses." info={'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'}
71
8.44E+18
8703745443229154634
2.60E+17
<stdin>:2:ReadTimeout: code=1200 [Coordinator node timed out waiting for replica nodes' responses] message="Operation timed out - received only 0 responses." info={'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'}
72
8.70E+18
8963558740041965220
2.60E+17
<stdin>:2:ReadTimeout: code=1200 [Coordinator node timed out waiting for replica nodes' responses] message="Operation timed out - received only 0 responses." info={'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'}
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