Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Help with regexp_extract sytax


Copy link to this message
-
Re: Help with regexp_extract sytax
Saurabh Nanda 2010-01-07, 04:49
Thanks, works now :-)

Saurabh.

On Wed, Jan 6, 2010 at 8:12 AM, Amr Awadallah <[EMAIL PROTECTED]> wrote:

> ; throwing it off, try:
>
>
> select to_date(ts), regexp_extract(cookies, '(urltrack__goo.*?\;)', 1)
> from hits where dt='2009-04' and lower(cookies) rlike
> '(.*)urltrack__goo(.*)'
> limit 5;
>
> On 1/5/2010 2:19 AM, Saurabh Nanda wrote:
>
>> Hi, I'm trying the following query but it doesn't seem to be syntactically
>> correct:
>>
>>
>> hive> select to_date(ts), regexp_extract(cookies, '(urltrack__goo.*?;)',
>> 1) from hits
>> > where dt='2009-04' and lower(cookies) rlike '(.*)urltrack__goo(.*)'
>> > limit 5;
>> FAILED: Parse Error: line 1:60 mismatched input '*' expecting Identifier
>> in expression specification
>>
>> Can anyone tell me what's wrong with my regept_extract expression?
>>
>> Thanks,
>> Saurabh.
>> --
>> http://nandz.blogspot.com
>> http://foodieforlife.blogspot.com
>>
>
--
http://nandz.blogspot.com
http://foodieforlife.blogspot.com