Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 20 Oct 2005 @ 09:23:41 GMT


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


Subj:   Why do I get a spool space error
 
From:   Anomy.Anom

<-- Anonymously Posted: Thursday, October 20, 2005 01:57 -->

Hi,

Please justify following behaviour in Teradata,

     1) select a.col1, a.col2, b.col3
        from   table1 a , ( select col3, col4 from table2 ) b
        where  a.col4 = b.col4 ;

Above statement gives spool space error.

     2) select a.col1, a.col2, b.col3
        from   table1 a , ( select col3, col4 from table2 group by 1,2) b
        where  a.col4 = b.col4 ;

Second query works fine and gives out put as per requirement. Only difference is group by.

Why spool space error is not generated in second case ??

Both tables contains huge data.


Thanks in advance.



     
  <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