[JBoss JIRA] (TEIID-4977) Support materialization as the 8.12.x version did
- First Post
- Replies
- Stats
-
Go to
- ----- 2025 -----
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2024 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
https://issues.jboss.org/browse/TEIID-4977?page=com.atlassian.jira.plugin...
]
Van Halbert commented on TEIID-4977:
------------------------------------
Format for -vdb.xml for the BEFORE and AFTER:
{code}
"teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute
{modelname}.native(''truncate {modelName}.{stagingCacheName}'');',
"teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute
{modelname}native(''rename {modelName}.{materializedCacheName}
{modelName}.{stagingCacheName}'');',
{code}
Example:
{code}
"teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute
StockJDGSource.native(''truncate StockJDGSource.ST_StockCache'');',
"teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute
StockJDGSource.native(''rename StockJDGSource.StockCache
StockJDGSource.ST_StockCache'');',
{code}
Support materialization as the 8.12.x version did
-------------------------------------------------
Key: TEIID-4977
URL: https://issues.jboss.org/browse/TEIID-4977
Project: Teiid
Issue Type: Feature Request
Components: Infinispan
Affects Versions: 8.12.x-6.4
Reporter: Van Halbert
Assignee: Ramesh Reddy
Priority: Critical
Attachments: ispn-vdb.xml, jdg-mat-cache-vdb.xml
Need to enable the materialization process to load the cache "offline" and not
impact access to current cache and data. This would be similar to how the 8.12.x version
was implemented and similar to how RDBMS materialization is done.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
3005
days inactive
3005
days old
0 comments
1 participants
tags (0)
participants (1)
-
Van Halbert (JIRA)