Hint: no_reflections should be registered in the HintStrategies

1

Hello,
I need to test a reflection and by documentation I see that I can tell Dremio to not use a reflection.
Unfortunately I get the error in the image and title of this post.

image
image1994×434 32.5 KB

I searched in Dremio documentation but I do not find any useful information. Can somebody help?

Thanks,

2

@coolo Will get back to you on this, meanwhile can you please try the ALTER SESSION and set it?

3

@coolo What version of Dremio are you on?

4

Hi @balaji.ramaswamy ,
thanks for the reply.

I am on Dremio 24.0.2

If I do the ALTER SESSION query I get this error:

image
image1264×784 31 KB

Kind regards,

5

Mind that the only Hint that works is BROADCAST. All the other ones do not.
For example, I attach the exclude_reflection try:

image
image2102×710 51.6 KB

I found the BROADCAST one here.

kr

6

@coolo That makes total sense as in 24.0 only broadcast hints were introduced while in 24.2 and higher Reflection hints are also added

7

I see, thanks for the explanation.