[
https://issues.jboss.org/browse/TEIIDDES-1794?page=com.atlassian.jira.plu...
]
Steven Hawkins commented on TEIIDDES-1794:
------------------------------------------
Ramesh is correct. You can just allow them on a virtual model and that will be
sufficient.
Not to confuse things, but the full array of temp table stuff we currently support is:
Teiid global temporary table (a virtual entry - which from an engine perspective can be on
any model type)
Teiid temporary table (not a schema entry in the design time metadata, scoped to a
session/block)
Teiid temporary table backed by a physical table (not a schema entry in the design time
metadata, scoped to a session/block - the physical table could be a temporary one)
Eventually we would also like to have an ease of use path to simply create a teiid
temporary table and have the backing table created on a source automatically - similar to
the data shipment join temporary table creation.
Designer support for global temporary tables
--------------------------------------------
Key: TEIIDDES-1794
URL:
https://issues.jboss.org/browse/TEIIDDES-1794
Project: Teiid Designer
Issue Type: Feature Request
Components: Modeling
Reporter: Mark Addleman
Assignee: Barry LaFond
Fix For: 8.4
Teiid has added support for a global temporary tables - they share a common definition,
but each session has their own instance. Internally this is modeled as a virtual table
(without a transformation) with a table type of "TemporaryTable" (int code 6).
If you provided matching index metadata we would recognize the entry as a global temporary
table.
Alternatively extension metadata could be used.
--
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