[teiid-issues] [JBoss JIRA] (TEIID-3076) Add materialized view to data-federation quick start

[Van Halbert (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3076?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Van Halbert resolved TEIID-3076.
--------------------------------

    Resolution: Done


Committed changes to the 2.0 version of quick starts

> Add materialized view to data-federation quick start
> ----------------------------------------------------
>
>                 Key: TEIID-3076
>                 URL: https://issues.jboss.org/browse/TEIID-3076
>             Project: Teiid
>          Issue Type: Enhancement
>      Security Level: Public(Everyone can see) 
>          Components: Quick Starts
>            Reporter: Van Halbert
>            Assignee: Van Halbert
>            Priority: Minor
>
> Adding the following materialized view to the portfolio VDB to materialized the stocks view to TTL of 2 minutes:
> 	CREATE view stockPricesMatView
> 		(
>             product_id integer,
>             symbol string,
>             price bigdecimal,
>             company_name   varchar(256)
>  		) OPTIONS (MATERIALIZED 'TRUE', UPDATABLE 'TRUE',
>                MATERIALIZED_TABLE 'Accounts.h2_stock_mat', 
>                "teiid_rel:MATVIEW_TTL" 120000,
>                "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute accounts.native(''truncate table h2_stock_mat'');',
>                "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT"  'execute accounts.native('''')', 
>                "teiid_rel:ON_VDB_DROP_SCRIPT" 'DELETE FROM Accounts.status WHERE Name=''stock'' AND schemaname = ''Stocks''',
>                "teiid_rel:MATERIALIZED_STAGE_TABLE" 'Accounts.h2_stock_mat',
>                "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true', 
>                "teiid_rel:MATVIEW_STATUS_TABLE" 'status', 
>                "teiid_rel:MATVIEW_SHARE_SCOPE" 'NONE',
>                "teiid_rel:MATVIEW_ONERROR_ACTION" 'THROW_EXCEPTION')
>  		AS SELECT  A.ID, S.symbol, S.price, A.COMPANY_NAME
>                     FROM Stocks.StockPrices AS S, Accounts.PRODUCT AS A
>                     WHERE S.symbol = A.SYMBOL;



--
This message was sent by Atlassian JIRA
(v6.2.6#6264)