> I have data in format

>
>
>     1,1.2
>
>     2,1.3
>
>     and so on..
>
>
>
> So basically this is id, val combination where id is unique...
>
>
>
> I want to calculate the average of all the values..
>
>
>
>     So here.. avg(1.2,1.3)
>
>
>
> I was going thru the documentation but most of the aggregation function
involves grouping by some id.. and then using AVG... but since the id is
unique.. how do I group them???
>
> So basically the outcome of this endeavor would be one float..
>
> Any suggestions will be greatly appreciated.
>
> Thanks

A = load 'input_file';
B = group A all;
C = foreach B generate AVG(A.$1);

This groups all of your records into one bag and then takes the average of the second column.

Alan.

On Nov 6, 2012, at 11:19 AM, jamal sasha wrote:

>> I have data in format
>
>>
>>
>>    1,1.2
>>
>>    2,1.3
>>
>>    and so on..
>>
>>
>>
>> So basically this is id, val combination where id is unique...
>>
>>
>>
>> I want to calculate the average of all the values..
>>
>>
>>
>>    So here.. avg(1.2,1.3)
>>
>>
>>
>> I was going thru the documentation but most of the aggregation function
> involves grouping by some id.. and then using AVG... but since the id is
> unique.. how do I group them???
>>
>> So basically the outcome of this endeavor would be one float..
>>
>> Any suggestions will be greatly appreciated.
>>
>> Thanks