1 of 1

Limit & Sampling

This page describes how to limit return and sample data in Kafka with Lenses SQL Studio.

Limit the output

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

Set a time limit for a query

To restrict the time to run the query, use SET max.query.time:

Sampling data

To sample data and discard the first rows:

This statement instructs Lenses to skip the first record matched and then sample the next two.