Hi everyone!
How disable COLLATE in Dremio? I tried set DREMIO_JAVA_EXTRA_OPTS='-Ddremio.jdbc.mssql.push-collation.disable=true' in dremio-env, but don’t work.
I’m having problems with Collate for fields UUID.
I’m using Dremio version 4.5.
Thanks!
When you do a “ps -ef | grep dremio”, does it show the flag attached?
Hello there, I know this is an older thread, but I’m facing the same issue. I set the flag as described on the first message and, since I couldn’t find a specific flag on the docs for pgsql, also set DREMIO_JAVA_EXTRA_OPTS='-Ddremio.jdbc.pgsql.push-collation.disable=true'. I just checked with ps and both flags were set, but I still got a query with collate in the jobs_log
@karynzv Are you able to send dremio-env from both coordinator and executor (masking passwords), output of ps -ef | grep dremio on both coordinator and executor and the job profile for the query.
If this is a Kubernetes environment then instead of dremio-env, send the values.yaml (masking any passwords),