liveBook · Manning

Query specification

As explained in ScyllaDB in Action

A query specification is a load-test configuration that defines a database query and how its input fields are generated.

A query specification is the part of a load-test configuration that tells cassandra-stress which database query to execute and how to generate its input fields. section 11.2.1

Reading article summaries

A read specification can execute `SELECT * FROM article_summaries_by_date WHERE date_bucket = ?` and use `fields: samerow` to supply the query value from one generated row.

How ScyllaDB in Action covers it

How deep it goes
Defines query syntax, field binding, value ranges, string sizes, and container setup, but does not detail test execution.
Examples
Uses article summaries, date buckets, scores, titles, author names, and a parameterized read query.
What it assumes
Assumes a target keyspace and table exist, while teaching field generation and query binding through configuration.
What you can do after
Operate cassandra-stress with a YAML workload that generates representative fields and executes defined reads.
How it connects
Connects YAML configuration, CQL queries, cassandra-stress, generated data, and ScyllaDB load testing.
Cover of ScyllaDB in Action
liveBookmanning.com
Read ScyllaDB in Action on liveBook Get the book at manning.com

This explainer was generated by Manning's knowledge graph from the text of ScyllaDB in Action. The section links point to the parts of the book it draws on.