[teiid-issues] [JBoss JIRA] (TEIID-196) Support creation of temp tables on physical sources.

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-196:
--------------------------------------

Satisfied the first item above by requiring a CREATE permission on the targeted schema.  This may require a designer change if they don't allow the user to select schema level permissions.
                
> Support creation of temp tables on physical sources.
> ----------------------------------------------------
>
>                 Key: TEIID-196
>                 URL: https://issues.jboss.org/browse/TEIID-196
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Connector API, Query Engine
>    Affects Versions: 6.0.0
>            Reporter: Ken Johnson
>            Assignee: Steven Hawkins
>             Fix For: 8.3
>
>
> This is a multi-part request.  
> First, the system should support creation of temporary tables using a physical backing store rather than buffer manger.  Given multi-pass SQL's heavy use of temp tables, buffer manager can easily be overloaded with large interim results stored in temp tables.
> Second, this should be a user-configurable behavior.  For example, user might be able to choose a system-level or session-level default from among:
>  -- memory/cache
>  -- a source represented by a connector binding
>  -- a distinct temp source defined with it's own connection parameters (possibly another schema in the repository DB instance)
> Ideally default selectoin should be override-able at temp table creation time through a DDL extension
> In the case where multiple temp tables have been created on a source via connector, the query planner should recognize this and leverage pushdown to the temp store when later query passes access multiple temp tables. 

--
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