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 [mailto:sprag...@gmail.com] Sent: Wednesday, June 12, 2013 1:00 PM To: user@hive.apache.org 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 <mark.sunder...@teamaol.com<mailto:mark.sunder...@teamaol.com>> wrote: 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: MESunderlin 22000 AOL Way, Dulles, VA 20166
