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
