Hi Team , I have Aggregate Reflection created on 2 different source tables . When i execute a query having these 2 source tables with join clause , Aggregate Reflections are not used. However Raw reflection is used. Please let me know if it is possible to accelerate query having join clause using Aggregate Reflection ?
Thanks,
KP
Also in the Raw Profile it says considered,matched,not chosen. What could be the reason for not chosen?
@pakiran Dremio is matching both the reflections but during cost estimation is choosing the raw reflection over the raw. Can you please turn on planner.verbose_profile then run the query, download the profile. Make sure to disable planner.verbose_profile and then send the profile over? For now, you can force using the Agg reflection by providing an optimizer hint