[teiid-issues] [JBoss JIRA] (TEIID-4132) Internal Mat View's teiid_rel:MATVIEW_PREFER_MEMEORY option not take effect
Steven Hawkins (JIRA)
issues at jboss.org
Fri Jun 3 17:04:01 EDT 2016
[ https://issues.jboss.org/browse/TEIID-4132?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins closed TEIID-4132.
---------------------------------
> 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
>
> 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)
More information about the teiid-issues
mailing list