[teiid-issues] [JBoss JIRA] (TEIID-4641) Create upsert/delete refresh support

[Steven Hawkins (JIRA)]

Steven Hawkins created TEIID-4641:
-------------------------------------

             Summary: Create upsert/delete refresh support
                 Key: TEIID-4641
                 URL: https://issues.jboss.org/browse/TEIID-4641
             Project: Teiid
          Issue Type: Sub-task
          Components: Query Engine
            Reporter: Steven Hawkins
            Assignee: Steven Hawkins


There must be an alternative to the implied default of the table rename strategy - which is problematic when a source is not transactional or even when it is - as a multi-part swap can leave the table non-existent for a brief window or the source may have issues with ddl under an xa transaction - TEIID-4579

This is true for the non-transactional source incremental refresh as well, which is a delete then insert - it leaves the live table briefly in an inconsistent state.

A upsert/delete approach addresses both of these concerns at the expense of performance - especially when the source does not directly support upsert as the engine must implement a compensating procedure.  However now that we have pushdown support for upsert, we'll continue to add source support.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)