i’m using a dremio cluster with 4 nodes, version 4.1.3.
In my case i have these vds:
- vds_a join
- vds_b -----------> vds_d
if i query vds_d (with a reflection on it) with a limit operator the query doesn’t uses the reflection on the vds_d but uses the reflection on the parent of the vds (a,b,c).
If the value of the limit is very high (near the value of input records in the “with-limit” profile), the query on vds_d use the reflection on it (profile truncated).