Thank you! On Tue, Aug 25, 2015 at 11:46 AM, Jason Altekruse <[email protected]> wrote:
> 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 > > >
