We have a job that we migrated from 8.5 to 11.5 which was giving incorrect results. We narrowed this down to a transformer messing up the sort order after reading from a sort stage.
We have tried changing the partition to "Same" but didnt work.
The only way the transformer appears to maintain the sort order is if it is run in Sequential mode.
I have also tried sorting again in the transformer using the same keys as the sort stage but that failed as well.
Any suggestions?
Sort order lost in transformer when migrated to 11.5
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 44
- Joined: Wed May 27, 2009 3:01 pm
If you set the partitioning to "same" and are not modifying the key column in the transformer, then the order won't be changed.
Turn on $APT_DUMP_SCORE and see what operators are actually being called; and perhaps you might try disabling combination of operators ($APT_DISABLE_COMBINATION) to see if that might be having an affect on your problem.
Turn on $APT_DUMP_SCORE and see what operators are actually being called; and perhaps you might try disabling combination of operators ($APT_DISABLE_COMBINATION) to see if that might be having an affect on your problem.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Each time I have seen "strange things" going on related to the Transformer stage, it has been caused by using the wrong compiler version. A major, minor, or fix pack difference in the compiler version can definitely cause unusual, incorrect behaviors. Double check system requirements' exact version listed against the version you have installed.
Choose a job you love, and you will never have to work a day in your life. - Confucius