Hive, mail # user - hive regular expression

hive regular expression

qiaoresearcher 2012-12-26, 18:46

Assume there are strings like

'afewexcvgregre&MovieTitle=321grgrdg&olfll3onsl'

or

'?MovieTitle=949303sjkskld&sososodn'
how to extract 'MovieTitle=321grgrdg' or 'MovieTitle=949303sjkskld' using
Hive reg expression functions
thanks
and happy holidays

Re: hive regular expression

Dean Wampler 2012-12-26, 18:50

Hive uses Java's regex API. This tutorial provides an excellent
introduction.

http://docs.oracle.com/javase/tutorial/essential/regex/

dean

On Wed, Dec 26, 2012 at 12:46 PM, qiaoresearcher
<[EMAIL PROTECTED]>wrote:

> Assume there are strings like
>
> 'afewexcvgregre&MovieTitle=321grgrdg&olfll3onsl'
>
> or
>
> '?MovieTitle=949303sjkskld&sososodn'
>
>
> how to extract 'MovieTitle=321grgrdg' or 'MovieTitle=949303sjkskld' using
> Hive reg expression functions
>
>
> thanks
> and happy holidays
>
>
--
*Dean Wampler, Ph.D.*
thinkbiganalytics.com
+1-312-339-1330

Re: hive regular expression

Matt Tucker 2012-12-26, 21:00

Parse_url and str_to_map may offer an alternative worth looking into.

On Dec 26, 2012, at 1:50 PM, Dean Wampler <[EMAIL PROTECTED]> wrote:

> Hive uses Java's regex API. This tutorial provides an excellent introduction.
>
> http://docs.oracle.com/javase/tutorial/essential/regex/
>
> dean
>
> On Wed, Dec 26, 2012 at 12:46 PM, qiaoresearcher <[EMAIL PROTECTED]> wrote:
>> Assume there are strings like
>>
>> 'afewexcvgregre&MovieTitle=321grgrdg&olfll3onsl'
>>
>> or
>>
>> '?MovieTitle=949303sjkskld&sososodn'
>>
>>
>> how to extract 'MovieTitle=321grgrdg' or 'MovieTitle=949303sjkskld' using Hive reg expression functions
>>
>>
>> thanks
>> and happy holidays
>
>
>
> --
> Dean Wampler, Ph.D.
> thinkbiganalytics.com
> +1-312-339-1330
>