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);
};