[
https://issues.apache.org/jira/browse/HIVE-20250?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16664120#comment-16664120
]
Jason Dere edited comment on HIVE-20250 at 10/25/18 6:27 PM:
-------------------------------------------------------------
Hey [~thai.bui], sorry didn't get around to working on this one.
How about going with the approach outlined
[here|https://issues.apache.org/jira/browse/HIVE-20250?focusedCommentId=16565715&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-16565715].
That would enable your case with the timeout approach. Feel free to try to
take up, or I will eventually get around to it when I get a chance.
Regarding the ability to receive notifications to invalidate the cache, there
is also HIVE-19154, where HS2 is able to listen on metastore notification
events to invalidate result cache entries. If you are able to generate a basic
ALTER TABLE or ALTER PARTITION statement on the table which results in the
metastore generating the notification event, this could suit your purposes.
Something like ALTER TABLE TOUCH might be useful here.
was (Author: jdere):
Hey [~thai.bui], sorry didn't get around to working on this one.
How about going with the approach outlined
[here|https://issues.apache.org/jira/browse/HIVE-20250?focusedCommentId=16565715&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-16565715].
That would enable your case with the timeout approach. Feel free to try to
take up, or I will eventually get around to it when I get a chance.
Regarding the ability to receive notifications to invalidate the cache, there
is also HIVE-19154, where HS2 is able to listen on metastore notification
events to invalidate result cache entries. If you are able to generate a basic
ALTER TABLE or ALTER PARTITION statement on the table which results in the
metastore generating the notification event, this could suit your purposes.
> Option to allow external tables to use query results cache
> ----------------------------------------------------------
>
> Key: HIVE-20250
> URL: https://issues.apache.org/jira/browse/HIVE-20250
> Project: Hive
> Issue Type: Sub-task
> Reporter: Jason Dere
> Priority: Major
> Attachments: HIVE-20250.1.patch
>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
