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_Materializat...], 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?