Archives of the TeradataForum
Message Posted: Fri, 16 Apr 2004 @ 13:55:22 GMT
Since you didn't specify and the fact you are running out of SPOOL, I am guessing that you are doing a UNION instead of a UNION ALL. By default, UNION eliminates duplicates. My estimation is that the redistribution necessary to eliminate dups is sending so many rows to one AMP that you are running out of space.
If there should never be duplicates, use UNION ALL. The side benefit is that it will be faster because of the elimination of an unnecessary execution step.
Hope this helps,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|