Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 22 Nov 2005 @ 19:13:07 GMT


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


Subj:   Out of spool and OLAP functions
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, November 22, 2005 13:50 -->

Has anyone encountered out of spool error, when running simple queries having olap functions like rank or csum on tables with 20 M rows, in 5.1 ? The query is straight forward with rank on a single table.The table is uniformly distributed across the AMPs. This used to run fine in V2R5. Didn't find recent threads on this? Is the problem already fixed in latest patches?



     
  <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: 15 Jun 2023