Collation in SQL server sources

1

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

2

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:
-Ddremio.jdbc.mssql.push-collation.disable=true

Then restart Dremio.

3

Thank you. It rocks.