Re: how to use builtin String functions

2011-01-13 Thread Dmitriy Ryaboy
Hm, a bunch of UDFs were moved into Pig builtins from piggybank for 0.8. Try building the piggybank and putting it on your classpath + registering it at the head of your script. On Thu, Jan 13, 2011 at 6:03 PM, Dexin Wang wrote: > jar tf pig-0.7.0_9-core.jar | grep builtin > > shows over 100 cla

Re: how to use builtin String functions

2011-01-13 Thread Dexin Wang
jar tf pig-0.7.0_9-core.jar | grep builtin shows over 100 class files like MIN, MAX, SUM, COUNT, etc but no UPPER or any other string function I want to use. Of course "grep UPPER" shows nothing. Which jar file are these string functions supposed to be in? On Thu, Jan 13, 2011 at 5:50 PM, Dmitri

Re: how to use builtin String functions

2011-01-13 Thread Dmitriy Ryaboy
Try this: jar tf pig.jar | grep UPPER to see fi the UDFs are in your jar, and what package they live in. On Thu, Jan 13, 2011 at 5:38 PM, Dexin Wang wrote: > Thanks. > > Somehow, it's not recognizing these functions. > > grunt> *DUMP A;* > (a-b-c,1) > (x-y,2) > (z,3) > grunt> *DESCRIBE A;* > A

Re: how to use builtin String functions

2011-01-13 Thread Dexin Wang
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

Re: how to use builtin String functions

2011-01-12 Thread Thejas M Nair
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 P

how to use builtin String functions

2011-01-12 Thread Dexin Wang
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. Encoun