Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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:


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.



  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023