[teiid-issues] [JBoss JIRA] (TEIID-4132) Internal Mat View's teiid_rel:MATVIEW_PREFER_MEMEORY option not take effect

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-4132.
-----------------------------------
    Resolution: Rejected


Not all properties are conveyed on the generated query - see GlobalTempTableStoreImpl.updateCacheHint and GlobalTableStoreImpl.createMatTable

> Internal Mat View's teiid_rel:MATVIEW_PREFER_MEMEORY option not take effect
> ---------------------------------------------------------------------------
>
>                 Key: TEIID-4132
>                 URL: https://issues.jboss.org/browse/TEIID-4132
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 9.x
>            Reporter: Kylin Soong
>            Assignee: Steven Hawkins
>             Fix For: 9.x
>
>
> From [https://teiid.gitbooks.io/documents/content/caching/Internal_Materialization.html], the "teiid_rel:MATVIEW_PREFER_MEMEORY" should be same as the pref_mem cache hint option. But in my debug, it's not convert to cache hint, for example, 
> {code}
> 		) OPTIONS (materialized true,
> 		    UPDATABLE 'TRUE',
> 			"teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true', 
>             "teiid_rel:MATVIEW_PREFER_MEMEORY" 'true',
>             "teiid_rel:MATVIEW_TTL" 300000,
>             "teiid_rel:MATVIEW_UPDATABLE" 'true', 
>             "teiid_rel:MATVIEW_SCOPE" 'VDB'
> 		)
> {code}
> In TempTableDataManager's loadGlobalTable() method, the cache hint is like
> {code}
> /*+ cache(updatable scope:VDB) */ 
> {code}
> also the _hint.isPrefersMemory()_ result is false.
> So how to understand "teiid_rel:MATVIEW_PREFER_MEMEORY" in internal mat? does this is expect behivior?



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)