[HIVE-21373] Expose query result cache info as a UDTF

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 4.0.0
• Labels: UDF
• Target Version/s: 4.0.0
• Assignee: Unassigned
• Reporter: Prasanth Jayachandran
• Created: 02/Mar/19 01:03
• Updated: 02/Mar/19 03:42

Description

To be able to look into the metadata of query result cache, like size, cache hit/miss, location etc. using query like

select * from query_cache();

will be good to expose these as a queryable table. 

Issue Links

• relates to: HIVE-21270 A UDTF to show schema (column names and types) of given query