Limit & Sampling
This page describes how to limit return and sample data in Kafka with Lenses SQL Studio.
Last updated
This page describes how to limit return and sample data in Kafka with Lenses SQL Studio.
Last updated
2024 © Lenses.io Ltd. Apache, Apache Kafka, Kafka and associated open source project names are trademarks of the Apache Software Foundation.
To limit the output of the query you can use two approaches:
use the LIMIT
clause
set the max size of the data to be returned
To restrict the time to run the query, use SET max.query.time
:
To sample data and discard the first rows:
This statement instructs Lenses to skip the first record matched and then sample the next two.