[ https://issues.jboss.org/browse/TEIID-1504?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-1504: ------------------------------------- Ok, that may be the misconception I had. It was in the user query, I will try with view definition. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-1504?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-1504. --------------------------------- Resolution: Rejected This is user error. The cache hint needs to be in the transformation of the view. When the cache hint is on the user query it only applies to the "resultset" caching, not internal materialized view. 1) Also, the cache hint defined on the view only invalidates the cache, does not automatically reload when TTL expires 2) The loading can occur a) if you re-issue the query, a async job is fired to load the matview contents, however until the matview is loaded the old results will be returned. b) if you do not like the loading strategy in (a), you can issue a "SYSADMIN.refreshmatview(viewname, invalidate)" system procedure call, to load the table immediately. c) You can also use "admin-console" to do the same operation as (b) using UI under VDB Control tab. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira