I know this is very common problem , i read lots of messages for this.

 But i was not able to see why its not working

 I am having serviceTransform1 , whose schema is given below.

 I am trying to generate SUM , COUNT for various fields in it.

 But somehow its not working.

 I am getting error

 *Could not infer the matching function for org.apache.pig.builtin.SUM as 
multiple or none of them fit. Please use an explicit cast.*


 serviceTransform1:
 {
 var_I: chararray,
 serviceLookup3::serviceLookup2::serviceLookup1::serviceFilter1::var_J: 
chararray,
 var_K: chararray,
 serviceLookup3::serviceLookup2::serviceLookup1::serviceFilter1::var_L: 
chararray,
 serviceLookup3::serviceLookup2::serviceLookup1::serviceFilter1::var_A: 
chararray,
 serviceLookup3::serviceLookup2::serviceLookup1::serviceFilter1::var_B: 
chararray,
 serviceLookup3::serviceLookup2::serviceLookup1::serviceFilter1::var_C: 
chararray,
 serviceLookup3::serviceLookup2::serviceLookup1::serviceFilter1::var_D: 
chararray,
 serviceLookup3::serviceLookup2::serviceLookup1::serviceFilter1::var_E: 
chararray,
 var_n: chararray,
 serviceLookup3::serviceLookup2::serviceLookup1::serviceFilter1::var_F: 
chararray,
 var_m: chararray,
 serviceLookup3::serviceLookup2::serviceLookup1::serviceFilter1::var_G: 
chararray,
 serviceLookup3::serviceLookup2::serviceLookup1::serviceFilter1::var_H: 
chararray
 }


 serviceTransform1Group = group serviceTransform1 ALL;

 serviceTransform2 = foreach serviceTransform1Group {

 inter = serviceTransform1.var_I;
 generate SUM(inter);
 };

Reply via email to