FAQ
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 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

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 3 | next ›
Discussion Overview
groupuser @
categorieshive, hadoop
postedFeb 4, '11 at 10:39a
activeFeb 4, '11 at 11:16a
posts3
users2
websitehive.apache.org

2 users in discussion

Amlan Mandal: 2 posts Jamie Cockrill: 1 post

People

Translate

site design / logo © 2021 Grokbase