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

General task tracking improvements for materialized views

    XMLWordPrintableJSON

    Details

    • Type: Task
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Materialized views
    • Labels:
      None

      Description

      We have a whole lot of tests from a different system that created and tested materialized views.

      This Jira serves as the parent task for all the shortcomings that were found when running these tests on Hive

        Attachments

          Issue Links

          1.
          Support for materialized view rewriting with window functions Sub-task Resolved Jesus Camacho Rodriguez  
          2.
          MV rewriting for distinct and count(distinct) not being triggered Sub-task Resolved Jesus Camacho Rodriguez  
          3.
          Rewriting fails when `IN` clause has items in different order in MV and query Sub-task Resolved Jesus Camacho Rodriguez

          100%

          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 50m
          4.
          Rewriting fails for `IN` clauses in MV and query when we use equals or subset in the query Sub-task Resolved Jesus Camacho Rodriguez  
          5.
          Rewriting fails for `BETWEEN` clauses with different ranges in MV and query Sub-task Resolved Jesus Camacho Rodriguez  
          6.
          Aggregate pushdown through join may generate additional rewriting opportunities Sub-task Open Vineet Garg  
          7.
          Ordinals in view are not being picked up in materialized view Sub-task Open Unassigned  
          8.
          Mappings.NoElementException: no target in mapping, in `MaterializedViewAggregateRule Sub-task Resolved Vineet Garg  
          9.
          Commutativity of operations is not taken into account, e.g., '+' Sub-task Resolved Vineet Garg  
          10.
          Materialized view rewriting does not support `UNION` operator, exact match can work under view Sub-task Open Unassigned  
          11.
          Degenerate case where mv not being used: computing aggregate on group by field Sub-task Open Unassigned  
          12.
          Aggregate after join throws off MV rewrite Sub-task Resolved Jesus Camacho Rodriguez

          100%

          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 20m
          13.
          Support for rewriting with materialized views containing grouping sets Sub-task Resolved Jesus Camacho Rodriguez

          100%

          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 0.5h
          14.
          Add support for `intersect` keyword in MV Sub-task Resolved Krisztian Kasa  
          15.
          MV query fails with CalciteViewSemanticException Sub-task Open Unassigned  
          16.
          MV fails for queries with subqueries Sub-task Open Unassigned  
          17.
          Optimize MV: Materialized views should not rebuild when tables are not modified Sub-task Resolved Krisztian Kasa

          100%

          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 2.5h
          18.
          Allow triggering materialized view rewriting for external tables Sub-task Resolved Jesus Camacho Rodriguez

          100%

          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 0.5h

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                scarlin Steve Carlin
              • Votes:
                0 Vote for this issue
                Watchers:
                8 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 4h 40m
                  4h 40m