Thanks, works now :-)
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
> 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
>> 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?