Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 27 Mar 2007 @ 11:31:20 GMT


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


Subj:   Re: Error 2513 -- A data row is too long
 
From:   Victor Sokovin

  The query below with 2-way join and select-list over 64k-byte long encounters error 2513  


          > Select tableA.pkey, tableB.* from tableA, tableB;

A tricky query to use for that purpose! I don't know what you mean by a 2-way join but from here the join looks like a Cartesian (cross) join.

The number of rows returned is the product of the number of rows in tableA and tableB. If on a test system the tables contained 1,000 rows each then the query would return 1 million rows. If on the prod machine you increased the number of rows to 10,000 rows then the result set would already contain 100 million rows, quite a different figure altogether. The system might not be able to handle this internally.

Anyway, there was a similar thread recently:

www.teradataforum.com/teradata/20070215_000000.htm


No suggestions for SysMaxRow tuning. I doubt it is tunable without NCR interference. You might need to give them a call or find yourself a more predictable test query.


Regards,

Victor



     
  <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