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 <[email protected]> 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 <[email protected]> > *To:* [email protected]; Sai Sai <[email protected]> > *Sent:* Friday, 24 May 2013 4:39 PM > *Subject:* Re: Difference between like %A% and %a% > > > 2013/5/24 Sai Sai <[email protected]> > > 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
