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

Switch to Threaded View
Pig, mail # user - how to use builtin String functions


Copy link to this message
-
Re: how to use builtin String functions
Dexin Wang 2011-01-14, 01:38
Thanks.

Somehow, it's not recognizing these functions.

grunt> *DUMP A;*
(a-b-c,1)
(x-y,2)
(z,3)
grunt> *DESCRIBE A;*
A: {code: chararray,v: int}
grunt> *B = FOREACH A GENERATE REGEX_EXTRACT_ALL(code, '(.*)-(.*)');*
2011-01-13 17:35:48,062 [main] ERROR org.apache.pig.tools.grunt.Grunt -
ERROR 1070: Could not resolve REGEX_EXTRACT_ALL using imports: [,
org.apache.pig.builtin., org.apache.pig.impl.builtin.]

It doesn't even like UPPER:

grunt> *C = FOREACH A GENERATE UPPER(code);   *
2011-01-13 17:37:51,317 [main] ERROR org.apache.pig.tools.grunt.Grunt -
ERROR 1070: Could not resolve UPPER using imports: [,
org.apache.pig.builtin., org.apache.pig.impl.builtin.]

On Wed, Jan 12, 2011 at 6:03 PM, Thejas M Nair <[EMAIL PROTECTED]> wrote:

>  The functions need to be part of an expression in a relational operator,
> for example -
>
> f = foreach l generate  REGEX_EXTRACT_ALL('192.168.1.5:8020',
> '(.*)\\:(.*)');
>
> (the above example does not make much sense as none of the columns in input
> relation are being used.)
>
> -Thejas
>
>
>
> On 1/12/11 5:43 PM, "Dexin Wang" <[EMAIL PROTECTED]> wrote:
>
> I see there are some builtin string functions, but I don't know how to use
> them. I got this error when I follow the examples:
>
> grunt> REGEX_EXTRACT_ALL('192.168.1.5:8020', '(.*)\:(.*)');
> 2011-01-12 19:34:23,773 [main] ERROR org.apache.pig.tools.grunt.Grunt -
> ERROR 1000: Error during parsing. Encountered " <IDENTIFIER>
> "REGEX_EXTRACT_ALL "" at line 1, column 1.
>
> Thanks.
>
>
>