[ https://issues.jboss.org/browse/TEIIDDES-3095?page=com.atlassian.jira.plu... ] Van Halbert commented on TEIIDDES-3095: --------------------------------------- The materialize settings for the new view will be different. An example xml based materialization is below: {code} CREATE VIEW Stock ( product_id integer, symbol string, price double, company_name string) OPTIONS (MATERIALIZED 'TRUE', UPDATABLE 'TRUE', MATERIALIZED_TABLE 'StockJDGSource.StockCache', "teiid_rel:MATERIALIZED_STAGE_TABLE" 'StockJDGSource.ST_StockCache', "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'TRUE', "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute StockJDGSource.native(''truncate StockJDGSource.ST_StockCache'');', "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute StockJDGSource.native(''rename StockJDGSource.ST_StockCache StockJDGSource.StockCache'');', "teiid_rel:MATVIEW_STATUS_TABLE" 'Accounts.status', "teiid_rel:MATVIEW_TTL" 10000, "teiid_rel:MATVIEW_ONERROR_ACTION" 'WAIT') AS SELECT Stocks.Stock.product_id, Stocks.Stock.symbol, CAST(Stocks.Stock.price AS double) AS price, Stocks.Stock.company_name FROM Stocks.Stock; {code} -- This message was sent by Atlassian JIRA (v7.2.3#72005)