Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 02 Oct 2003 @ 13:02:29 GMT


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


Subj:   Re: Plastic Steps
 
From:   Geoffrey Rommel

  Can someone explain what is meant by 'plastic steps'?  



See the SQL Reference, Vol. 2, esp. the section "Generator". I quote:

The Generator creates a series of directives for the AMPs that contain column and row information, but no literal data values. The steps, called plastic steps, are later transformed into concrete steps by Apply. Plastic steps allow sets of values taken from the USING modifier to be inserted during subsequent operations.


  We recently changed DBS Control setting MaxParseTreeSegs from 64 to 1000 and now we are receiving this error.  


That's a lot of parse tree segments, unless you are using Teradata Warehouse Builder or some other product that is generating gnarly SQL. If you are, then the recommendation to increase the SegmentSize makes sense to me.



     
  <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: 23 Jun 2019