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
