When a query will cause more than millions of rows data be returned, what will happend?
Thanks
When a query will cause more than millions of rows data be returned, what will happend?
Thanks
@WileyXu, if you write a query that returns millions of records, Dremio will run the query and return those records (in Apache Arrow format) to whatever storage you’ve configured for the Dremio results store (see: https://docs.dremio.com/deployment/distributed-storage.html)
Your browser (Safari, Chrome etc) will request pages of that data as you scroll through the results. It will not try to load them all at once. The Dremio web UI uses this API to do that: https://docs.dremio.com/rest-api/jobs/get-job.html
Wow, it is great. Thanks