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
