[teiid-issues] [JBoss JIRA] (TEIID-2584) Add management features to materialization

[Ramesh Reddy (JIRA)]

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

Ramesh Reddy commented on TEIID-2584:
-------------------------------------

Will this work?

{code}
create procedure refreshMatView(viewName, criteria) AS
BEGIN
   mv = getMV($viewName)
   delete from $mv where $criteria;
   select * into $mv from (loadscript) AS X where $criteria
END
{code}

for above, I will have the proper transitions of status in the "matview status" table.

Since I was using select transformation when load script is not provided, this information is needed now. Will move Transformations to Triggers, and move from extension properties to proper column names like

{code}
create table Triggers (
  schema string;
  table string;
  type string; -- valid values (SELECT, INSERT, UPDATE, DELETE, INSTEAD OF INSERT, INSTEAD OF UPDATE, INSTEAD OF DELETE)
  sql_stmt string;
);
{code}
                
> Add management features to materialization
> ------------------------------------------
>
>                 Key: TEIID-2584
>                 URL: https://issues.jboss.org/browse/TEIID-2584
>             Project: Teiid
>          Issue Type: Feature Request
>            Reporter: Ramesh Reddy
>            Assignee: Ramesh Reddy
>              Labels: Beta3
>             Fix For: 8.5
>
>
> Currently Teiid supports internal and external materialization features. The internal is managed completely by the Teiid query engine along with the infinispan cache. 
> External materialization is completely unmanaged and left out to the user to manage it externally. This goals for this feature are unify the materialization logic for internal and external, such that both are managed similarly irrespective of the type of materialization chosen. 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira