Aggregator

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kittu.raja
Premium Member
Premium Member
Posts: 175
Joined: Tue Oct 14, 2008 1:48 pm

Aggregator

Post by kittu.raja »

Hi,

I want to find out the count of file. So I am using the design

Seq File ----> agg ---->seq File.

I am geeting an error saying that "Aggregator_7: When checking operator: Operator of type "APT_HashedGroup2Operator": will partition despite the
preserve-partitioning flag on the data set on input port 0."

I am using hash partitioning in the aggregator stage. I searched in the forums but did not find the solution.

Any help would be appreciated

Thanks,
Rajesh Kumar
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

How is the Preserve Partitioning flag set on the stage that is upstream of the Aggregator?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
betterthanever
Participant
Posts: 152
Joined: Tue Jan 13, 2009 8:59 am

Re: Aggregator

Post by betterthanever »

select "CLEAR" preserve partioning falg upstream...
kittu.raja
Premium Member
Premium Member
Posts: 175
Joined: Tue Oct 14, 2008 1:48 pm

Re: Aggregator

Post by kittu.raja »

I kept as clear, but still I am getting this warning.
Rajesh Kumar
kittu.raja
Premium Member
Premium Member
Posts: 175
Joined: Tue Oct 14, 2008 1:48 pm

Post by kittu.raja »

Ray, I put clear in all the stages, but still I am getting this warning
Rajesh Kumar
betterthanever
Participant
Posts: 152
Joined: Tue Jan 13, 2009 8:59 am

Re: Aggregator

Post by betterthanever »

set "CLEAR" to stage downstream and see
kittu.raja
Premium Member
Premium Member
Posts: 175
Joined: Tue Oct 14, 2008 1:48 pm

Re: Aggregator

Post by kittu.raja »

there are no more stages to set clear in downstream.
Rajesh Kumar
betterthanever
Participant
Posts: 152
Joined: Tue Jan 13, 2009 8:59 am

Re: Aggregator

Post by betterthanever »

the aggregator not connected to any stages downstream???
kittu.raja
Premium Member
Premium Member
Posts: 175
Joined: Tue Oct 14, 2008 1:48 pm

Re: Aggregator

Post by kittu.raja »

It is connected to Sequential file.
Rajesh Kumar
betterthanever
Participant
Posts: 152
Joined: Tue Jan 13, 2009 8:59 am

Re: Aggregator

Post by betterthanever »

on the outputside of aggregator stage set the preserve partioning to "CLEAR"
kittu.raja
Premium Member
Premium Member
Posts: 175
Joined: Tue Oct 14, 2008 1:48 pm

Re: Aggregator

Post by kittu.raja »

Yes I did but I am getting the same error. I set all the stages to clear in the preserver partitioning tab but no use.
Rajesh Kumar
parilango
Participant
Posts: 10
Joined: Thu Jun 23, 2016 8:36 am

Re: Aggregator

Post by parilango »

I am also getting the same warning after the partion set as CLEAR also.

any solution please
parimala
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

parilango - If would be best if you started a new post with all of the details of your version of this issue, including the job design and actual error message.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply