Drill supports ILIKE for case insensitive matching. Be aware that it is treated like a regular function, as Steven notes here: https://issues.apache.org/jira/browse/DRILL-3301
This doc page should be changed to include it, I'll open a pull request. https://drill.apache.org/docs/operators On Tue, Aug 25, 2015 at 9:31 AM, John Omernik <[email protected]> wrote: > Hey all, I see LIKE is case sensitive (similar to Hive, different then > MySQL etc). Do we have any options for a case insensitive like? Either at > a system level (like a system variable) or another function we can use to > mimic a case insensitive LIKE? Thanks in advance! > > John >
