Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 16 Apr 2004 @ 13:55:22 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Union and Spool space error
 
From:   Michael Larkins

Rohit:

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,

Michael Larkins
Certified Teradata Master



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016