[ZEPPELIN-5915] zeppelin query result cache,improve query performance

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: duanxiaoqiu
• Created: 23/May/23 07:22
• Updated: 09/Jun/23 05:58

Description

Analysts proposed that in Adhoc queries often appear because of insufficient consideration, or less writing conditions lead to a lot of repeated queries, in order to solve this problem we made an automatic cache function, when SQL has Shuffle operation we will automatically save the SQL result to a temporary table in hive, and feedback the temporary table to the user. In this way, users can use temporary tables to do iterative queries when writing less conditions or doing some exploratory queries, reducing some duplicate queries

 

so ,i want to add query result to cache to improve performance

Issue Links

• links to: GitHub Pull Request #4611

Sub-Tasks

• improve query efficiency—deal complex sql: Open
• improve query efficiency—data cache: Open