i have infraestructure with docker, one dremio as coordinator and 3 dremio as executors and i setting up a minio server as s3 distributed storage for reflections, downloads, etc.
we are been using dremio from dremio 18. but now we ecountered a problem with dremio 23, where any of the reflection we make for our querys match.
btw, we have a dremio 20 with exectuor and coordinator all in one, and this exact query with the same datasources and same reflections, and it works, only with the dremio distributed does not work.
Your profile shows a bunch of exceptions while matching on specific reflections. You could enable DEBUG logging to get the stack traces to see if that helps. This is pretty verbose so you only want this on to debug this problem:
I see three reflections hit the union/join limit. You could try increasing that limit with the support option: reflections.planning.algebraic_match_limit
The location that you setup for the dist storage for reflections shouldnât affect how the query planner does reflection matching.
i try it putting down on logback.xml, but isnât working. maybe its because this is a docker and docker does not have a logfiles.
i try it with new deployment with nfs-server as distributed path with test data, but i getting the same error on using reflection, the issue its seem to appear from dremio 21, because i try it dremio 20, dremio 21 dremio 22, dremio 23, with same config and only dremio 20 its capable of getting reflections from distributed path. this are my config for setting up the server. dremio.conf.zip (1,0 KB)
i try it with nfs-server, minio-s3, and hadoop. 169f99f4-2a89-404c-8fff-418a3ef7d939.zip (48,6 KB)
I assume TEST.test1 should have matched? Do you have the profile when it was matched in the lower version? we will try and reproduce this issue and provide an update
UPDATE: dremio 23 still not working, we test again on clean installation on new servers, and dremio 22.1.1 its working. b55446b1-7d39-48e4-8eaf-43472599cb0c.zip (18,4 KB)
Iâm having the exact same problem. Since our upgrade to v23 our raw reflections never match. In the acceleration profile I see that it âcaughtâ some exceptions during substitution.
This was an upgrade from an lower version. Started at 20 upgraded consecutively to 21, 22 and finally 23. With runs of dremio-admin inbetween each upgrade