hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jamie Cockrill <jamie.cockr...@gmail.com>
Subject Re: case insensitive string equality
Date Fri, 04 Feb 2011 10:49:45 GMT
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