case insensitive columns
My company has a strong need to be able to search via case insensitive columns - such as address which is virtually impossible to specify because of all of the variations of how the incoming data were supplied in terms of case.
Is this possible on a Linux based MariaDB columns store instance?
Answer Answered by David Thompson in this comment.
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.