[teiid-issues] [JBoss JIRA] Commented: (TEIID-1504) Internal Materialization does not honr the cache hint
[
https://issues.jboss.org/browse/TEIID-1504?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1504:
---------------------------------------
Is this hint in a user query or in the query defining the view?
If it's in the user query, it would be a hint for resultset caching, not
materialization.
Internal Materialization does not honr the cache hint
-----------------------------------------------------
Key: TEIID-1504
URL: https://issues.jboss.org/browse/TEIID-1504
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.2
Reporter: Ramesh Reddy
Assignee: Steven Hawkins
Fix For: 7.4
When a internal materialization is loaded with /*+ cache(pref_mem ttl:120000)*/ select *
from view.g1, to does not refresh/flush the matview contents from memory after two minutes
(120000). Upon inspecting the code, it looks like the Cache Hint is being on searched on
the created temp table rather than the original query.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira