Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-20773

Query result cache might contain stale MV data

Log workAgile BoardRank to TopRank to BottomAdd voteVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Critical
    • Resolution: Unresolved
    • 4.0.0
    • None
    • Materialized views
    • None

    Description

      A user can specify “required freshness” of data in a materialized view via

      hive.materializedview.rewriting.time.window=<time>

       

      If a query is executed against stale data, its result will be cached by HiveServer2 to avoid re - execution at a later point in time. This cache will now contain stale data. A different query session might not be able to tolerate stale data or have a shorter acceptable time window. Right now, it will receive the query result cache content independent of its own hive.materializedview.rewriting.time.window setting, potentially leading to unexpected results.

      Attachments

        Activity

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

          People

            Unassigned Unassigned Assign to me
            odraese Oliver Draese

            Dates

              Created:
              Updated:

              Issue deployment