Page 1 of 1

agregator

Posted: Tue Nov 27, 2007 7:36 am
by scorpion
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

Posted: Tue Nov 27, 2007 8:11 am
by Maveric
See if this post helps:

viewtopic.php?t=114245

Posted: Tue Nov 27, 2007 9:11 am
by scorpion
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?

Posted: Tue Nov 27, 2007 11:37 pm
by Maveric
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.