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 Plain View
Pig >> mail # user >> Internal error 2999 - misuse of CONCAT? misuse of GROUP?


+
william.dowling@... 2011-04-05, 20:10
Copy link to this message
-
Re: Internal error 2999 - misuse of CONCAT? misuse of GROUP?


Do you need the group-key to be concatenated ? If not, you can just group on all the three columns -

 TCGroupedByFuid = group TCRaw by (SrcFuid.citingdocid,
                                         SrcFuid.col,
                                        SrcFuid.seq);

If you want the group key to be concatenated for some reason, you can see if generating a concatenated string helps.
Which version of pig are you using ? From the stack trace, it looks like the version is an old(er) one. This issue might have been fixed in a newer version of pig.

-Thejas
On 4/5/11 1:10 PM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
 dump TCRaw;
 TCGroupedByFuid = group TCRaw by CONCAT((chararray)SrcFuid.citingdocid,
                                          SrcFuid.col,
                                         (chararray)SrcFuid.seq);
 store TCGroupedByFuid into 'foo';

+
Xiaomeng Wan 2011-04-05, 22:53
+
william.dowling@... 2011-04-06, 18:17
+
Xiaomeng Wan 2011-04-06, 19:27
+
william.dowling@... 2011-04-06, 18:09
+
Thejas M Nair 2011-04-06, 19:30
+
Thejas M Nair 2011-04-06, 19:42
+
william.dowling@... 2011-04-06, 19:50
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