Limitation of the Pivot Stage?
Posted: Sat Jul 03, 2004 4:22 pm
I'm curious if anyone is aware of any limitations in the use of the Pivot stage? One of my developers who makes heavy use of it is having problems trying to pivot one row into more than 64 rows.
Now, don't ask me the whys or the wherefors. I'm not really sure why he needs to do what he is trying to do, but he tells me 64 works fine. Adding in the 65th field to the output derivation craters the job. And no, I don't know the exact error message. Yet. And it's probably not a coincidence that the limit seemingly is a power of two.![Wink :wink:](./images/smilies/icon_wink.gif)
I'll take a closer look at the job and see about alternate approaches on Tuesday, but right now I'm just curious if anyone else has seen or heard of an issue like this.
![Confused :?](./images/smilies/icon_confused.gif)
Now, don't ask me the whys or the wherefors. I'm not really sure why he needs to do what he is trying to do, but he tells me 64 works fine. Adding in the 65th field to the output derivation craters the job. And no, I don't know the exact error message. Yet. And it's probably not a coincidence that the limit seemingly is a power of two.
![Wink :wink:](./images/smilies/icon_wink.gif)
I'll take a closer look at the job and see about alternate approaches on Tuesday, but right now I'm just curious if anyone else has seen or heard of an issue like this.