· 6 years ago · May 05, 2019, 06:50 AM
1keyspace: stresscql
2
3keyspace_definition: |
4 CREATE KEYSPACE IF NOT EXISTS stresscql WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 };
5
6table: table1
7
8table_definition: |
9 CREATE TABLE table1 (
10 id int,
11 clustering timeuuid,
12 data1 text,
13 data2 text,
14 PRIMARY KEY(id, clustering)
15 ) WITH CLUSTERING ORDER BY (clustering DESC)
16
17columnspec:
18 - name: id
19 size: gaussian(5..50)
20 population: uniform(1..5M)
21
22 - name: clustering
23 cluster: fixed(1000)
24
25 - name: data1
26 size: uniform(30..300)
27
28 - name: data2
29 size: gaussian(100..5000)
30
31insert:
32 partitions: fixed(1)
33 select: fixed(1)/1000
34 batchtype: UNLOGGED
35
36queries:
37 range:
38 cql: SELECT * FROM table1 WHERE id >= ? AND id <= ? ALLOW FILTERING
39 fields: samerow
40 range_count:
41 cql: SELECT count(1) FROM table1 WHERE id >= ? AND id <= ? ALLOW FILTERING
42 fields: samerow
43 range_and_eq:
44 cql: SELECT * FROM table1 WHERE id >= ? AND id <= ? AND data1=? ALLOW FILTERING
45 fields: samerow