agregator

scorpion · Post by **scorpion** » Tue Nov 27, 2007 7:36 am

hi all,
I have 10 input columns passing to an aggregator stage in my job.and i am doing sum on column xxx.Thais column is passing to next stage like sum_xxx.
and i dont want to groupby this column xxx.and i need this column available for next stage.(not sum_xxx,but only xxx)
so how to get this column out(pass to next stage)with out mentioning in groupby?
any one have idea?help would be appreciated.

thanks

Maveric · Post by **Maveric** » Tue Nov 27, 2007 8:11 am

See if this post helps:

viewtopic.php?t=114245

scorpion · Post by **scorpion** » Tue Nov 27, 2007 9:11 am

Thanks maveric for your reply.

this post is seems to be help full for me,but could you clarify one thing ,when defining sort stage ,which column do i need to mention to sort.

is it column xxx or different?

Maveric · Post by **Maveric** » Tue Nov 27, 2007 11:37 pm

Not on xxx. That is the calculation field. The sort keys should be same as the aggregator stage keys. In SQL terms the sort and group by keys should be same.