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

should be

TCGroupedByFuid = group TCRaw by CONCAT((chararray)SrcFuid::citingdocid,CONCAT(
                                         SrcFuid::col,
                                        (chararray)SrcFuid::seq));

Shawn

On Wed, Apr 6, 2011 at 12:17 PM,  <[email protected]> wrote:
> -----Original Message-----
> From: Xiaomeng Wan [mailto:[email protected]]
> Sent: Tuesday, April 05, 2011 6:54 PM
> To: [email protected]
> Subject: Re: Internal error 2999 - misuse of CONCAT? misuse of GROUP?
>
> concat only takes two fields at a time. use concat(field1,
> concat(field2, field3))
>
> Shawn
> --------------------------
>
>
> Hi Shawn,
>
> Thanks for your response.  I have tried supplying just two arguments to 
> CONCAT(), but I get the same
>
> ERROR 2999: Unexpected internal error. null
>
> java.lang.NullPointerException
>
> that I originally reported.  It's a good tip to use only two arguments, but I 
> think something else is (also) going on.  Thanks!
>
> Will
>

Reply via email to