#
# This is an example YAML profile for cassandra-stress
#
# insert data
# cassandra-stress user profile=/home/jake/stress1.yaml ops(insert=1)
#
# read, using query simple1:
# cassandra-stress profile=/home/jake/stress1.yaml ops(simple1=1)
#
# mixed workload (90/10)
# cassandra-stress user profile=/home/jake/stress1.yaml ops(insert=1,simple1=9)

#ignoring errors
#./cassandra-stress user cl=QUORUM profile=/home/ubuntu/stress.yaml ops\(insert=1\) -node 10.20.15.45 -errors ignore -rate threads=1000#
#
# Keyspace info
#
keyspace: summit_stressv4

#
# The CQL for creating a keyspace (optional if it already exists)
#

#
# Table info
#
table: test_tablev4

#
# The CQL for creating a table you wish to stress (optional if it already exists)
#
#keyspace_definition: |
#  CREATE KEYSPACE summit_stressv4 WITH replication = {'class': 'NetworkTopologyStrategy', 'us-east': '3'} AND durable_writes = true;

#USE summit_stress;

# CREATE TABLE test_tablev4 (
#   rowkey text,
#   C0 blob,
#   C1 blob,
#   C2 blob,
#   C3 blob,
#   C4 blob,
#   sortkey timestamp,
#   PRIMARY KEY (rowkey)
# ) WITH
#   bloom_filter_fp_chance=0.010000 AND
#   caching='KEYS_ONLY' AND
#   comment='table example for cassandra summit' AND
#   dclocal_read_repair_chance=0.100000 AND
#   gc_grace_seconds=0 AND
#   index_interval=128 AND
#   read_repair_chance=0.000000 AND
#   replicate_on_write='true' AND
#   populate_io_cache_on_flush='false' AND
#   speculative_retry='99.0PERCENTILE' AND
#   memtable_flush_period_in_ms=0 AND
#   compaction={'timestamp_resolution': 'MICROSECONDS', 'class': 'DateTieredCompactionStrategy', 'max_sstable_age_days': '1', 'base_time_seconds': '60', 'min_threshold': '4'} AND
#   compression={'chunk_length_kb': '128', 'sstable_compression': 'LZ4Compressor'};

#
# Optional meta information on the generated columns in the above table
# The min and max only apply to text and blob types
# The distribution field represents the total unique population
# distribution of that column across rows.  Supported types are
#
#      EXP(min..max)                        An exponential distribution over the range [min..max]
#      EXTREME(min..max,shape)              An extreme value (Weibull) distribution over the range [min..max]
#      GAUSSIAN(min..max,stdvrng)           A gaussian/normal distribution, where mean=(min+max)/2, and stdev is (mean-min)/stdvrng
#      GAUSSIAN(min..max,mean,stdev)        A gaussian/normal distribution, with explicitly defined mean and stdev
#      UNIFORM(min..max)                    A uniform distribution over the range [min, max]
#      FIXED(val)                           A fixed distribution, always returning the same value
#      Aliases: extr, gauss, normal, norm, weibull
#
#      If preceded by ~, the distribution is inverted
#
# Defaults for all columns are size: uniform(4..8), population: uniform(1..100B), cluster: fixed(1)
#
#columnspec:
#  - name: name
#    size: uniform(1..10)
#    population: uniform(1..1M)     # the range of unique values to select for the field (default is 100Billion)
#  - name: date
#    cluster: uniform(20..40)
#  - name: lval
#    population: gaussian(1..1000)
#    cluster: uniform(1..4)

insert:
  partitions: uniform(1)          # number of unique partitions to update in a single operation
                                  # if batchcount > 1, multiple batches will be used but all partitions will
                                  # occur in all batches (unless they finish early); only the row counts will vary
  select: uniform(4..5)/10       # uniform chance any single generated CQL row will be visited in a partition;
                                  # generated for each partition independently, each time we visit it
  #batchtype: UNLOGGED               # type of batch to use


columnspec:
    - name: C0
      size: fixed(34)
    - name: C1
      size: fixed(34)
    - name: C2
      size: fixed(34)
    - name: C3
      size: fixed(34)
    - name: C4
      size: fixed(34)


#
# Insert settings
#

insert:
    partitions: fixed(1)
    select: fixed(4)/4
    batchtype: UNLOGGED

#
# A list of queries you wish to run against the schema
#
queries:
   simple:
     cql: select * from test_tablev4 where rowkey = ? LIMIT 10;
     fields: multirow             # samerow or multirow (select arguments from the same row, or randomly from all rows in the partition)