query-some-columns.yaml

# Stress profile to test for CASSANDRA-10657

keyspace: ks

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

table: tbl

table_definition: |
  CREATE TABLE tbl (
        key int PRIMARY KEY,
        small_val1 int,
        large_val1 blob,
        small_val2 int,
        large_val2 blob
  )
  WITH compression = { 'sstable_compression':'' };

columnspec:
  - name: small_val1
    size: fixed(10)
  - name: large_val1
    size: fixed(100K)
  - name: small_val2
    size: fixed(10)
  - name: large_val2
    size: fixed(100K)

queries:
   all_cols:
      cql: select * from tbl where key = ?
   only_small:
      cql: select small_val1, small_val2 from tbl where key = ?