like this:
CONCAT(CONCAT('all', ':'), 'all')
It's ugly , but the concat only accepts 2 parameters.
Here's the java doc of CONCAT class:
/**
* Generates the concatenation of the first two arguments. It can be
* used with two bytearrays or two chararrays (but not a mixture of the two).
*/
Haitao Yao
[email protected]
weibo: @haitao_yao
Skype: haitao.yao.final
在 2012-7-10，下午10:04， Cdy Chen 写道：
> Hi all,
>
> I am a new comer here. I encounter a problem toady:
>
> Pig version: 0.10.0
>
> temp2 = LOAD '/pig/procedure/tzone' USING PigStorage(';');
> zone = FOREACH temp2
> {
> a = STRSPLIT($0,'#',3);
> product = STRSPLIT(a.$1,'-',2);
> key = CONCAT((chararray)product.$1,(chararray)$7,(chararray)$6);
> GENERATE
> key,product.$1,TRIM($10),TRIM($4),TRIM($7),TRIM($9),TRIM($8),TRIM($14),TRIM($1),TRIM($6);
> };
>
> It still shows an error:
> ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1045:
> <line 21, column 9> Could not infer the matching function for
> org.apache.pig.builtin.CONCAT as multiple or none of them fit. Please use
> an explicit cast.
>
> Please help!
>
> Thanks!
> Chen
