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

Materialized view registry does not clean non existing views at refresh

    XMLWordPrintableJSON

Details

    Description

      CBO plans of materialized views which are enabled for query rewrite are cached in HS2 (MaterializedViewsCache, HiveMaterializedViewsRegistry)

      The registry is refreshed periodically from HMS:

      set hive.server2.materializedviews.registry.refresh.period=1500s;
      

      This functionality is required when multiple HS2 instances are used in a cluster: MV drop operation is served by one of the HS2 instances and the registry is updated at that time in that instance. However other HS2 instances still cache the non-existent view and need to be refreshed by the updater thread.
      Currently the updater thread adds new entries, refresh existing ones but does not remove the outdated entries.

      Attachments

        Issue Links

          Activity

            People

              kkasa Krisztian Kasa
              kkasa Krisztian Kasa
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 2h 10m
                  2h 10m