hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Amlan Mandal <am...@fourint.com>
Subject Re: case insensitive string equality
Date Fri, 04 Feb 2011 11:16:04 GMT
Jamie,
Yes I can use LIKE or lcase /lower but instead of using that every time it
would have better if I could use some setting. (like collation or something
in MySQL)

Amlan


On Fri, Feb 4, 2011 at 4:19 PM, Jamie Cockrill <jamie.cockrill@gmail.com>wrote:

> 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 <amlan@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
>>
>
>

Mime
View raw message