hello everyone, not sure if here's the right place to ask, but I would like to get 50K+ rows from a datasource and download them as csv. However the Druid query returns max 1,000 results. I know there's a key:

threshold

, but what's the best practice to query?

Are you using the web console for the query? If so there is an option to disable the 1000 row limit. Druid row limits are configurable, however, for very large queries you may be better off using the asynchronous MSQ based query engine.

oh I didn't know that option. Thank you so much @Benjamin Hopp!