[teiid-issues] [JBoss JIRA] (TEIID-1822) Dynamically Defined Materialized Views

[Mark Addleman (Commented) (JIRA)]

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

Mark Addleman commented on TEIID-1822:
--------------------------------------

I think we can close this feature request out.  I'm pretty sure that we can implement everything we need by plugging into the AuthorizationValidator interface.  Of course, at some point, we'll end up asking that it be made a stable API :)
                
> Dynamically Defined Materialized Views
> --------------------------------------
>
>                 Key: TEIID-1822
>                 URL: https://issues.jboss.org/browse/TEIID-1822
>             Project: Teiid
>          Issue Type: Feature Request
>            Reporter: Mark Addleman
>            Assignee: Steven Hawkins
>
> I'd like to be able to query a dynamically defined materialized view.  For example, suppose I issue the query
>    /* mat-view */ SELECT * FROM blah WHERE x='abc'
> Optionally (probably based on a hint), I'd like the following query to execute against the data set returned by the previous query rather than going back to the data source:
>    /* use-mat-view */ SELECT * FROM (SELECT * FROM blah WHERE x='abc') GROUP BY a
> To make this truly useful, I'd like to define indexes.  Something like:
>    /* mat-view(index-on:a,b,c) */ SELECT * FROM blah WHERE x='abc'

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira