[teiid-issues] [JBoss JIRA] (TEIID-4626) Add a full snapshot refresh strategy based upon table modifications

Ramesh Reddy (JIRA) issues at jboss.org
Fri Feb 24 13:47:00 EST 2017


    [ https://issues.jboss.org/browse/TEIID-4626?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13369181#comment-13369181 ] 

Ramesh Reddy commented on TEIID-4626:
-------------------------------------

That part I agree with :)  In that case, I will introduce additional property like {{MATVIEW_ALLOWED_STALENESS_PCT}} and Default this to 1%, where we can calculate the current staleness using
{code}
cardinality/stalecount
{code}
One the threshold is reached, will flip the {{Status}} table Status to "NEEDS_LOADING" to let it load.

> Add a full snapshot refresh strategy based upon table modifications
> -------------------------------------------------------------------
>
>                 Key: TEIID-4626
>                 URL: https://issues.jboss.org/browse/TEIID-4626
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Ramesh Reddy
>             Fix For: 9.3
>
>
> using the existing full materialization refresh logic we can trigger a refresh based upon a notion of how dirty a table is based upon a proportion of rows updated to the rows in the table. This would also require some change to the status table to capture the number of transitive row updates.  This could then be hooked up to debezium as the event source.



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


More information about the teiid-issues mailing list