Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 22 Nov 2005 @ 22:32:56 GMT


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


Subj:   Re: Out of spool and OLAP functions
 
From:   Eric Friedman

  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?  


We're having exactly this same problem. Used to work fine in earlier versions. NCR says they're working on the problem, but it's been at least 3 months with no reported progress.


Eric Friedman



     
  <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