You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@pig.apache.org by Latha <us...@gmail.com> on 2008/10/19 20:10:35 UTC

Piglatin "matches" operator not working.

Greetings!
Hi All,

 A = load 'file' using PigStorage(' ') as (key , value);
B = filter A by key matches '*Database*'

matches is not working for me.
...
        at
org.apache.hadoop.mapred.TaskTracker$Child.main(TaskTracker.java:2122)
 java.util.regex.PatternSyntaxException: Dangling meta character '*' near
index 0 *Database*


Could you pls suggest how to use matches with a regular  expression say
"*Database*"?

Thankyou
Srilatha

Re: Piglatin "matches" operator not working.

Posted by Daniel Dai <da...@gmail.com>.
Hi, Latha,
Try to use regular expression. 

A = load 'file' using PigStorage(' ') as (key , value);
B = filter A by key matches '.*Database.*';

Daniel

----- Original Message ----- 
From: "Latha" <us...@gmail.com>
To: <pi...@incubator.apache.org>
Sent: Sunday, October 19, 2008 2:10 PM
Subject: Piglatin "matches" operator not working.


> Greetings!
> Hi All,
> 
> A = load 'file' using PigStorage(' ') as (key , value);
> B = filter A by key matches '*Database*'
> 
> matches is not working for me.
> ...
>        at
> org.apache.hadoop.mapred.TaskTracker$Child.main(TaskTracker.java:2122)
> java.util.regex.PatternSyntaxException: Dangling meta character '*' near
> index 0 *Database*
> 
> 
> Could you pls suggest how to use matches with a regular  expression say
> "*Database*"?
> 
> Thankyou
> Srilatha
>

Re: Piglatin "matches" operator not working.

Posted by Latha <us...@gmail.com>.
Thankyou Daniel! Was following  link http://wiki.apache.org/pig/PigLatin
that used direct * for matching.
Now, the script works fine.

Regards,
Srilatha

On Mon, Oct 20, 2008 at 12:00 AM, Daniel Dai <da...@gmail.com> wrote:

> Hi, Latha,
> Try to use regular expression.
> A = load 'file' using PigStorage(' ') as (key , value);
> B = filter A by key matches '.*Database.*';
>
> Daniel
>
> ----- Original Message ----- From: "Latha" <us...@gmail.com>
> To: <pi...@incubator.apache.org>
> Sent: Sunday, October 19, 2008 2:10 PM
> Subject: Piglatin "matches" operator not working.
>
>
>
>  Greetings!
>> Hi All,
>>
>> A = load 'file' using PigStorage(' ') as (key , value);
>> B = filter A by key matches '*Database*'
>>
>> matches is not working for me.
>> ...
>>       at
>> org.apache.hadoop.mapred.TaskTracker$Child.main(TaskTracker.java:2122)
>> java.util.regex.PatternSyntaxException: Dangling meta character '*' near
>> index 0 *Database*
>>
>>
>> Could you pls suggest how to use matches with a regular  expression say
>> "*Database*"?
>>
>> Thankyou
>> Srilatha
>>
>>