Memory Issue on planning phase

When i submit a query that join 2 table, got the error:
dremio query was cancelled because it exceeded the memory planning.

After that I increase the memory on executors, from 96GB > 102 > 110, but still get this error. At the end, I have to setup 128GB on each executor, and then it work fine. I checked on profile file, nodes memory consume just around 15GB. Can you support me on this case?

Hi @nghiabq What version of Dremio is this?

Hello @balaji.ramaswamy, Dremio version is 19.0 enterprise, using Yarn for executors

@nghiabq Can you please enable planner.memory.aggressive and then retry the job?