Pull query
A pull query is an on-demand query that retrieves a point-in-time result from current or materialized data and terminates after returning it.
Kafka Streams in Action, Second Edition
A pull query retrieves point-in-time results from a materialized store instead of continuously receiving pushed results.
- How it is used
- Serves synchronous request-response lookups that must return a current result before work continues.
- How deep it goes
- Defines one-time execution, contrasts query modes, and shows a keyed WHERE lookup; defers specific SQL restrictions.
- Examples
- Demonstrates a key-based lookup of Smith in the activity_leaders table.
- What you can do after
- Apply it via ksqlDB to retrieve a one-time current result and reissue requests for updates.
Read how Kafka Streams in Action, Second Edition explains pull query →
Kafka for Architects
A pull query is an on-demand query that retrieves the current state of data and terminates after returning its result.
- How it is used
- Answers one-time questions about the current state of stream, table, or materialized-view data.
- How deep it goes
- Explains transient execution and contrasts topic scanning with materialized-view lookup.
- Examples
- Uses an order-status question and a filtered high-value-orders query.
- What you can do after
- Apply it via ksqlDB to retrieve current results without deploying a continuously running application.
Related concepts
- continuous querycontrasts with · A continuous query remains active and incrementally emits updated results as new data arrives.
- where clauseuses · A WHERE clause is a query-language clause that restricts returned or affected records to those satisfying a specified predicate.
- materialized viewuses · A materialized view is a persistently stored result of a defining query that can be read without recomputing it and is refreshed or maintained from underlying data.
These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.