cqlsh_tests/blogposts.yaml

### DML ###

keyspace: stresscql

keyspace_definition: |
  CREATE KEYSPACE stresscql WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 3};

table: blogposts

table_definition: |
  CREATE TABLE blogposts (
        domain text,
        published_date timeuuid,
        url text,
        author text,
        title text,
        body text,
        PRIMARY KEY(domain, published_date)
  ) WITH CLUSTERING ORDER BY (published_date DESC)
    AND compaction = { 'class':'LeveledCompactionStrategy' }
    AND comment='A table to hold blog posts'

### Column Distribution Specifications ###

columnspec:
  - name: domain
    size: gaussian(5..100)
    population: uniform(1..10M)

  - name: published_date
    cluster: fixed(5000)

  - name: url
    size: uniform(10..50)

  - name: title
    size: gaussian(5..10)

  - name: author
    size: uniform(5..10)

  - name: body
    size: gaussian(10..100)

### Batch Ratio Distribution Specifications ###

insert:
  partitions: fixed(1)     # insert 1 partition per batch

  select:    fixed(1)/500  # insert 10 rows per partition

  batchtype: UNLOGGED


queries:
   singlepost:
      cql: select * from blogposts where domain = ? LIMIT 1
      fields: samerow
   timeline:
      cql: select url, title, published_date from blogposts where domain = ? LIMIT 10
      fields: samerow