hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sunderlin, Mark" <>
Subject RE: Issues with Hive 'Like" and multiple '%' wildcard in a pattern
Date Wed, 12 Jun 2013 17:26:48 GMT
We are using Hive 0.80.

Mark E. Sunderlin
Solutions Architect |AOL Networks BDM
P: 703-265-6935     |C: 540-327-6222 | AIM: MESunderlin
22000 AOL Way | Dulles, VA | 20166

From: Stephen Sprague []
Sent: Wednesday, June 12, 2013 1:00 PM
Subject: Re: Issues with Hive 'Like" and multiple '%' wildcard in a pattern

that seems pretty hard to believe. what version of hive are you using?

On Wed, Jun 12, 2013 at 6:27 AM, Sunderlin, Mark <<>>
This seems to work just fine in other SQLs, but doesn't seem work in hive.

I need to have several wild card characters in my 'like' clause as follows.

In other SQLs, I want:  ....  where page_url_query like '%?icid=main%dl%'

But in Hive that doesn't match.  I have several work arounds.  I can write it as:

 where (page_url_query like '%?icid=main%')  and (page_url_query like '%dl%')

or, I can just use something like where length(regexp_extract(page__url_query, '.*\?cdid-main.*dl.*',0)
<> 0

But more important is two or more '%' wild cards in a Hive like expression a known issue?

Mark E. Sunderlin
Solutions Architect   |AOL NETWORKS BDM
P: 703-265-6935<tel:703-265-6935>       |C: 540-327-6222<tel:540-327-6222> | AIM:
22000 AOL Way,  Dulles, VA  20166

View raw message