Amlan, In: http://wiki.apache.org/hadoop/Hive/LanguageManual/UDF#String_Functions
<http://wiki.apache.org/hadoop/Hive/LanguageManual/UDF#String_Functions>It looks like you could use 'RLIKE' to achieve what you're after if you make a case-insensitive java regular expression. Thanks, Jamie On 4 February 2011 10:38, Amlan Mandal <am...@fourint.com> wrote: > (Please pardon my ignorance as I am Hive newbie) > > When I do Hive QL > select * from app_log where partner='abc'; > and > select * from app_log where partner='ABC' > > I get different result. That means by default Hive string equality is case > sensitive . Is there any GLOBAL/Hive wide setting so that string equality is > case insensitive? > > Amlan >
