March 8, 2023, 6:46pm
Hello, I am investigating Dremio cloud and deployed into AWS. I had an issue that led me to manually configuring dremio-env settings. What is the best way to set these type of settings with the cloud deployment?
Settings documented here.
March 8, 2023, 9:18pm
dremio-env settings aren’t supported in Dremio Cloud. The documentation link you provided is for Dremio Software.
What is the issue you are having? We may have a different way of configuring it in Dremio Cloud.
March 8, 2023, 11:32pm
Trying to disable the collation.
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
Honestly not sure that will fix my issue, I am trying to connect to a cockroachdb database. But when I investigated the issue, and if I removed the Collate “C” the generated query did work.