Uploaded image for project: 'Zeppelin'
  1. Zeppelin
  2. ZEPPELIN-5915

zeppelin query result cache,improve query performance

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None
    • None

    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

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            zhugezifang duanxiaoqiu

            Dates

              Created:
              Updated:

              Slack

                Issue deployment