Unnest ~7000 records takes too long and times out

I am new to using dremio. I am running it inside a docker container (with persistent vol). Unnesting (~7K records) data is taking too long and often times out. How do I go about getting results quickly? I need to unnest even larger data sets.



Kindly send us the profile

Share a query profile


All the time is on the FLATTEN. What happens if you try RUN instead of PREVIEW?

Thank you! That worked.


We have fixed the FLATTEN with LIMIT issue in 4.3.1, kindly upgrade and validate