It is not really a bug, as must as it is the way hive is designed. https://issues.apache.org/jira/browse/HIVE-4070#comment-13666362
So there already is a 'like' and an 'rlike', mlike is a good idea. It seems like an easier UDF (low hanging fruit) type issue anyone could tackle. On Fri, May 24, 2013 at 9:16 AM, Dean Wampler <deanwamp...@gmail.com> wrote: > Hortonworks has announced plans to make Hive more SQL compliant. I suspect > bugs like this will be addressed sooner or later. It will be necessary to > handle backwards compatibility, but that could be handled with a hive > property that enables one or the other behaviors. > > On Fri, May 24, 2013 at 8:07 AM, John Omernik <j...@omernik.com> wrote: > >> I have mentioned this before, and I think this a big miss by the Hive >> team. Like, by default in many SQL RDBMS (like MSSQL or MYSQL) is not >> case sensitive. Thus when you have new users moving over to Hive, if they >> see a command like "like" they will assume similarity (like many other SQL >> like qualities) and thus false negatives may ensue. Even though it's >> different by default (I am ok with this ... I guess, my personal preference >> is that it matches the defaults on other systems, and outside of that >> (which I am, in in the end fine with, just grumbly :) ) give us the ability >> to set that behavior in the hive-site.xml. That way when an org realizes >> that it is different, and their users are all getting false negatives, they >> can just update the hive-site and fix the problem rather than have to >> include it in training that may or may not work. I've added this comment >> to https://issues.apache.org/jira/browse/HIVE-4070#comment-13666278 for >> fun. :) >> >> Please? :) >> >> >> >> >> On Fri, May 24, 2013 at 7:53 AM, Dean Wampler <deanwamp...@gmail.com>wrote: >> >>> Your where clause looks at the abbreviation, requiring 'A', not the >>> state name. You got the correct answer. >>> >>> >>> On Fri, May 24, 2013 at 6:21 AM, Sai Sai <saigr...@yahoo.in> wrote: >>> >>>> But it should get more results for this: >>>> >>>> %a% >>>> >>>> than for >>>> >>>> %A% >>>> >>>> Please let me know if i am missing something. >>>> Thanks >>>> Sai >>>> >>>> >>>> ------------------------------ >>>> *From:* Jov <am...@amutu.com> >>>> *To:* user@hive.apache.org; Sai Sai <saigr...@yahoo.in> >>>> *Sent:* Friday, 24 May 2013 4:39 PM >>>> *Subject:* Re: Difference between like %A% and %a% >>>> >>>> >>>> 2013/5/24 Sai Sai <saigr...@yahoo.in> >>>> >>>> abbreviation l >>>> >>>> >>>> unlike MySQL, string in Hive is case sensitiveļ¼so '%A%' is not equal >>>> with '%a%'. >>>> >>>> >>>> -- >>>> Jov >>>> blog: http:amutu.com/blog <http://amutu.com/blog> >>>> >>>> >>>> >>> >>> >>> -- >>> Dean Wampler, Ph.D. >>> @deanwampler >>> http://polyglotprogramming.com >>> >> >> > > > -- > Dean Wampler, Ph.D. > @deanwampler > http://polyglotprogramming.com
