Apache Druid

what do you mean? Druid will stream the response, you can request either by CSV or JSONL so you can parse each row without waiting for the EOL

<https://druid.apache.org/docs/latest/querying/sql-api.html#responses>

i am fetching data from druid using python but after every 5 min it throws and error and only able to fetch 1 million records but actual data present is more than 100 times than this .

try passing in the context query a new timeout (or no timeout) <https://druid.apache.org/docs/latest/querying/sql-query-context.html>

Query timeout in millis, beyond which unfinished queries will be cancelled. 0 timeout means `no timeout` (up to the server-side maximum query timeout, `druid.server.http.maxQueryTimeout`). To set the default timeout and maximum timeout, see <https://druid.apache.org/docs/latest/configuration/index.html#broker|Broker configuration>

Pass some positive value, the broker has a default of 5min, so you need to pass a value greater than this