I have a VDS that is composed of a combination from other VDS.
I’ve created the basic raw reflections, which ran without any issue.
However, this reflection is not used when doing a basic select * from this VDS.
Any way to understand why ? (query profile attached)8667078e-b555-41ca-95d5-857406fb6347.zip (44.7 KB)
Thanks for reporting this. We are always trying to improve our reflection matching code. I will take a closer look at the profile and see if it’s related to some known issues we’ve discovered recently.
I don’t know for sure if this is the case, but it does look similar to some issues that we fixed for 2.1.6. You could try upgrading and see if it has been fixed in your case.
If not, could you rerun the query, but first turn on the verbose profile via the advanced option:
planner.verbose_profile.
This will provide additional information that might help us figure out the problem.