Does Lenses have a limit of data that can be queried from Kafka?
How can I change this limit and what happens if you exceed this limit, what are the consequences?
You can change the amount of data used in the query by adding the flag within your SQL Studio prompt:
SET max.size=1g
Increasing the limit allows you to get more results, but it will also increase the outgoing Kafka broker traffic.
Having more data to process in the query may lead to longer execution time, which can impact other queries running.
If the query is affecting other queries, you can use commands like
SHOW QUERIES
and
KILL QUERY
For more details, you can consult the documentation at these links: SQL query tuning | Lenses.io Documentation and Manage running queries | Lenses.io Documentation.