reflection_id: ‘3b3b6900-27c4-41d9-8e34-4446104d8518’
DONE materialization_id: 384d9e64-5960-447f-a807-bb248dab9080
Deprecated materialization_id :c1c24549-da21-49eb-9a58-966737952a2a
I observe a wired thing that when i running a reflection of a vds, it hit the deprecated materialization which got failed, on the other hand , when i run the same sql without save it into reflection, it hit the latest materialization.
can i know how to ask the optimizer to pick up the done materializaed reflection instead? any setting to do with?
btw, any reason materialized reflection will change from done to deprecated status? and if for deprecated reflection, can it be use?
thanks
dremio v19 community version