I have sql Query with 4-5 join query with Dataset already created and reflected ,but when i am querying dremio triying error with Skipping materialization e6fd8c59-02f3-41cf-8837-8d12951f400b due to large Join-Union size during substitutions,and also status looks frogen stil running from 1 hour .is any steps need to follow for Joins multiple table with relection enable so that its accelerated .
attaching job profile and screens
a1c310cb-3f50-44ac-ae81-0394b3d6ff0d.zip (175.8 KB)
@Vikash_Singh What happens if you create a VDS with fewer joins and then create the reflection on top of it, then fire a query on this new VDS, does it use reflection?