;select city from junk where city like '%West%v%';
> +-+
> | city|
> +-----+
> | West Haven |
> | West Haven |
> | West Haven |
> | West Haven |
> | West Covina |
> | West Covina |
> +-+
> 6 affected
>
&
AS case2
FROM DUAL - A dummy single row, single column table we installed
case1 case2
F T
---
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...@gma
gt; *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 ha
: 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
mailto:mark.sunder...@teamaol.com>> wrote:
This seems to work just fine in other S
that seems pretty hard to believe. what version of hive are you using?
On Wed, Jun 12, 2013 at 6:27 AM, Sunderlin, Mark 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 othe
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 w