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

[Kylin Soong (JIRA)]

Kylin Soong created TEIID-4132:
----------------------------------

             Summary: 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)