You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by John Omernik <jo...@omernik.com> on 2015/08/25 18:31:51 UTC
Case Sensitivity: LIKE
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
Re: Case Sensitivity: LIKE
Posted by John Omernik <jo...@omernik.com>.
Thank you!
On Tue, Aug 25, 2015 at 11:46 AM, Jason Altekruse <al...@gmail.com>
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 <jo...@omernik.com> 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
> >
>
Re: Case Sensitivity: LIKE
Posted by Jason Altekruse <al...@gmail.com>.
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 <jo...@omernik.com> 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
>