ColumnStore is case sensitive for string comparisons in queries.
I know that the following query
select * from table1 where field1='aaa';
can be made not case sensitive writing
select * from table1 where field1 collate utf8_general_ci='aaa';
but, is there a way to make the engine not cs by default, without changing the client code?
There should be an option for this.