Different results from using the same join query with reflection vs without reflection

1

Hi,

We are using the latest snowflake connector from the Dremio hub with Dremio version 17.0.0. We have one query which gives correct results only when the reflection is on. When the reflection is off, we don’t get the expected results. Have attached two job/query profiles, one with and one without reflection when executing the same exact query.

Let us know if we are missing something.

Regards,
Farhan.

without_reflection.zip (18.8 KB)
with_reflection.zip (19.2 KB)

2

@Farhan Seems like the join between the snowflake table and the other accelerated dataset is not producing any results, can you try to refresh metadata and the reflection and retry?

3

Hi @balaji.ramaswamy, tried again after refreshing metadata and reflection. No success.

4

@Farhan since this is a custom connector, someone should look at the code, are you able to send me the profile of the refresh reflection?