I agree with Prashant. I am hard pressed to find a case where it would be
useful, and I would much rather it fail on parse than while running.
2012/2/15 Prashant Kommireddi
> AVG over chararrays is not a usual case, simply because it does not make
> sense in most cases. For eg, what would be the
AVG over chararrays is not a usual case, simply because it does not make
sense in most cases. For eg, what would be the average if it were a bag of
first or last names? AVG would fail if it tried to convert String to
Integer or Double.
In your case its the best to declare it int/long if you know t
I solve this problem by extending the build in AVG function to accept char
array bag as input and calculate the result.
why the build-in AVG can not accept the char array bag and convert the value to
double and calculate the result?
在 2012-2-15，下午4:04， Jonathan Coveney 写道：
> the issue is tha
the issue is that doing (int)b.x does not cast each column to an int, but
rather, it tries to cast the bag itself. Short of flattening out the bag
and projecting it as an int, which is inefficient, I suppose you could make
a UDF that calculate the Average of chararrays by casting to an int...but
th
hi, all
here's my pig script:
A = load 'input' as (b:bag{t:(x:int, y:int)});
B = foreach A generate AVG(b.x);
describe B;
it works well.
if the b.x is char array, the problems arise:
A = load 'input' as (b:bag{t:(x:chararray, y:int)});
B = foreach A generate AVG((int)b.x);
2012-02-15 14
