Target: When checking operator:Sequential....

logic · Post by **logic** » Thu Jul 14, 2005 4:22 pm

Hi,
I am getting the following error when I am trying to write to a table

Target: When checking operator: Sequential operator cannot preserve partitioning of parallel dataset on input port 0

I am using all defaults. Which area should i look into for this warning.
Any comments will be helpful.
thanks,
Ash.

ray.wurlod · Post by **ray.wurlod** » Thu Jul 14, 2005 8:35 pm

It's an informational message indicating that collection of data from all processing nodes must occur because you're performing an operation (export to a sequential file) that can only happen sequentially.

thebird · Post by **thebird** » Thu Jul 14, 2005 11:22 pm

Hi Ash,

I believe you can get rid of this issue by setting the Preserve Partitioning property to "Clear", in the Advanced tab of the stage. By default this is set to Propagate (or Sequential depending on the stage).

Regards,

The Bird.

logic · Post by **logic** » Fri Jul 15, 2005 10:31 am

Hi,
Thanks. Setting the preserve partitioning to Clear helped.
Ash.