[
https://issues.jboss.org/browse/TEIID-4526?page=com.atlassian.jira.plugin...
]
Van Halbert commented on TEIID-4526:
------------------------------------
the above approach of using updatematViewRow is not correct because its updating the
actual row in the mat view table without applying the actual View transformation logic.
So what is needed is the ability to call SYSADMIN.refreshMatViewRow (example: EXEC
SYSADMIN.refreshMatViewRow('TestMat.SAMPLEMATVIEW', '{id}') )
But even that really won't work, because on a very complex view transformation, the
table change could be for a table in a subselect of the view transformation. The key
value of the row change is not enough to limit the subselect correctly. Which could
return the wrong results if its used in an "IN" subselect because other data is
no longer included in the subselect.
The only way to ensure the correct result is to only trigger the update when the
"key" can be identified in a change. Am I over thinking this? Is there
something simpler?
Integrate with Debezium for CDC for maintaining materialized views
------------------------------------------------------------------
Key: TEIID-4526
URL:
https://issues.jboss.org/browse/TEIID-4526
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 9.2
Reporter: Van Halbert
Assignee: Steven Hawkins
Priority: Critical
Integrate with Debezium so that Teiid will be able to consume and react to the row-level
change events and do something interesting with them, such as update the materialized
view(s).
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)