Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
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.
>
>
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB