One or more nodes ran out of memory while executing the query

1

I got this error message:

One or more nodes ran out of memory while executing the query.

while running a rest api query. I changed both:

DREMIO_MAX_HEAP_MEMORY_SIZE_MB

DREMIO_MAX_DIRECT_MEMORY_SIZE_MB

to 32GB from the default, but not sure if that helps…

Any recommendations?

2

@trang you should check the job profile for the failing job to see if you are running out of Heap or Direct memory. Typically, direct is the first offender.
For heap, unless you’re experiencing out of heap issues I’d go with 16GBs (upper end) for optimal GC.