Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Pig >> mail # user >> How to CONCAT multiple expressions


Copy link to this message
-
Re: How to CONCAT multiple expressions
I really need to fix this in pig 0.11

Russell Jurney
twitter.com/rjurney
[EMAIL PROTECTED]
datasyndrome.com

On Jul 10, 2012, at 5:34 PM, Cdy Chen <[EMAIL PROTECTED]> wrote:

> Thank you !
>
> I use
>
> key2 = CONCAT($1,$6);
> key = CONCAT(key2,$8);
>
> It also works!
>
> Regards,
> Chen
>
> 2012/7/10 Haitao Yao <[EMAIL PROTECTED]>
>
>> 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
>>
>>