Comments - case insensitive columns
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
I tried but MariaDB ColumStore does not support the syntax in DDL. I also tried to change the parameter in my.conf - but that didn't work either.
I did try in regular MariaDB and it works fine.
Here's an example of the DDL that worked in regular bot not in ColumnStore.
partner VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci,
I am very happy with what I have seen in MariaDB ColumnStore but if we cannot search values as case insentive, we will not be able to move forward.
Thanks for your suggestion.
Has anyone else run into this problem with ColumnStore and figured out a way around it?
I'm also in the same boat, after importing data into ColumnStore I wanted to check that a few of our usual queries would work but the string comparisons are always case sensitive despite the table collation been set to utf8_general_ci
If anyone has a solution I would love to hear about it
A key thing to remember is that columnstore implements its own set of 'distributed functions' that are executed at the pm level for scaling out query execution. At this point in time we don't support the collations that allow case insensitive matching. https://jira.mariadb.org/browse/MCOL-495 tracks an enhancement request to allow case insensitive matching.
The only solution for now is to store another column where you convert the text to lower case (or upper case) and then match on that with a lower case value.