[
https://issues.jboss.org/browse/TEIIDDES-2970?page=com.atlassian.jira.plu...
]
Van Halbert updated TEIIDDES-2970:
----------------------------------
Description:
When a view is being materialized for JDG, set the following extension properties:
<vhalbert> "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute
{jdgsourcemodelname}.native(''swap cache names'');'
<vhalbert> "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute
{jdgsourcemodelname}.native(''truncate cache'');',
teiid_rel:MATERIALIZED_STAGE_TABLE" '{jdgsourcemodelname}.{stagingTable}')
where {jdgsourcemodelname} as the new JDG Source Model that is created.
was:
When a view is being materialized for JDG, set the following extension properties:
<vhalbert> "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute
{jdgsourcemodelname}.native(''swap cache names'');'
<vhalbert> "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute
{jdgsourcemodelname}.native(''truncate cache'');',
where {jdgsourcemodelname} as the new JDG Source Model that is created.
Set default MatView Extension Properties for JDG materialization
----------------------------------------------------------------
Key: TEIIDDES-2970
URL:
https://issues.jboss.org/browse/TEIIDDES-2970
Project: Teiid Designer
Issue Type: Enhancement
Components: Modeling
Affects Versions: 10.0.2
Reporter: Van Halbert
Assignee: Barry LaFond
Fix For: 10.0.2
When a view is being materialized for JDG, set the following extension properties:
<vhalbert> "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute
{jdgsourcemodelname}.native(''swap cache names'');'
<vhalbert> "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute
{jdgsourcemodelname}.native(''truncate cache'');',
teiid_rel:MATERIALIZED_STAGE_TABLE" '{jdgsourcemodelname}.{stagingTable}')
where {jdgsourcemodelname} as the new JDG Source Model that is created.
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)