Raw reflection not used

11

Hey @ben thanks so much for responding.
I am on Dremio
Build: 3.1.6-201903070042400578-fdcd3a8
Edition: Community Edition

I have seen couple of situations where reflections are not used.
I posted two of those here

  1. No acceleration for queries with "SQL WITH" clause (sub-query refactoring)
  2. Reflection refresh is not accelerated if it involves a JOIN

I have been trying to write the queries in all sorts of manner to get it to pick up the reflection :tired_face:
I am used to periscopedata’s cache. For large queries, I create a cache and run queries on that. It fails on dremio because of what @kelly described as Reflections are associated with the query tree that defines the VDS rather than the VDS itself.