Collation in SQL server sources

Since release 1.3.0 the collation in SQL server sources is binary. It is slow because the generated SQL select contains COLLATE for string comparison, all values in column are converted and then indexes cannot be utilized.
Is it possible to configure in Dremio the SQL database default collation and remove the COLLATE keyword from push down select? Thanks

Hi @Pavel,

You can disable generation of the COLLATE clauses.

Modify the dremio-env file under /conf.

Uncomment out JAVA_EXTRA_OPS near the bottom and add this:

Then restart Dremio.

Thank you. It rocks.