Unnest ~7000 records takes too long and times out

1

Hi,
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.

Thanks.

2

@drem

Kindly send us the profile

Share a query profile

4

@drem

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

5

Thank you! That worked.

6

@drem

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

Thanks
@balaji.ramaswamy