Hello, guys! I’m testing Dremio 11.00 AWS edition and I’m constantly getting this error message when trying to create Aggregation Reflections on my dataset. The strange thing is that on 4.9.3 or earlier I wasn’t getting this error and could create this reflection without any issues.
I’m joining a fact table (fato_vendas) with its dimensions (depara_lojas, depara_produtos, depara_tempo) in order to create a flat view (fato_vendas_enriquecida) to make me able to create its aggregation reflection with all needed dimensions.
My reflection list:
The elastic engine responsible for creating reflections is made by 2 x m5d.8xlarge (256GB memory total).
Here’s the High Cost Reflections queue settings:
Here’s the query profile.
8d31dd35-efa8-4c8f-92d6-cb373848f89f.zip (55.7 KB)
One thing I noticed is that the node that is triggering this memory error is the master coordinator node but I already tried changing this machine type to the largest one available: m5d.8xlarge, with no success.
Is there anything I can do to fix this?