To avoid running into this, we need a change from TM.
TM should return an error when it's close to reaching some thrashold after which it is unable to handle a very large transactional operation. It will be iaccurate to rely on compielr estimates to guess that this limit may be reached.
Once TM makes this change, we will add better error handling at the SQL layer to handle this error and return a meaningful error message .
For the specific upsert with index case, refer to the wiki page that talks about how upsert with index or other indexes is a transactional operation. The recommendation is to disable the index before the upsert. https://wiki.trafodion.org/wiki/index.php/Data_Loading
To avoid running into this, we need a change from TM.
TM should return an error when it's close to reaching some thrashold after which it is unable to handle a very large transactional operation. It will be iaccurate to rely on compielr estimates to guess that this limit may be reached.
Once TM makes this change, we will add better error handling at the SQL layer to handle this error and return a meaningful error message .
For the specific upsert with index case, refer to the wiki page that talks about how upsert with index or other indexes is a transactional operation. The recommendation is to disable the index before the upsert. /wiki.trafodion .org/wiki/ index.php/ Data_Loading
https:/