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

General task tracking improvements for materialized views

Log workAgile BoardRank to TopRank to BottomAdd voteVotersWatch issueWatchersCreate sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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   Actions
        2.
        MV rewriting for distinct and count(distinct) not being triggered Sub-task Resolved Jesus Camacho Rodriguez   Actions
        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
        Actions
        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   Actions
        5.
        Rewriting fails for `BETWEEN` clauses with different ranges in MV and query Sub-task Resolved Jesus Camacho Rodriguez   Actions
        6.
        Aggregate pushdown through join may generate additional rewriting opportunities Sub-task Open Vineet Garg   Actions
        7.
        Ordinals in view are not being picked up in materialized view Sub-task Open Unassigned   Actions
        8.
        Mappings.NoElementException: no target in mapping, in `MaterializedViewAggregateRule Sub-task Resolved Vineet Garg   Actions
        9.
        Commutativity of operations is not taken into account, e.g., '+' Sub-task Resolved Vineet Garg   Actions
        10.
        Materialized view rewriting does not support `UNION` operator, exact match can work under view Sub-task Open Unassigned   Actions
        11.
        Degenerate case where mv not being used: computing aggregate on group by field Sub-task Open Unassigned   Actions
        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
        Actions
        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
        Actions
        14.
        Add support for `intersect` keyword in MV Sub-task Resolved Krisztian Kasa   Actions
        15.
        MV query fails with CalciteViewSemanticException Sub-task Open Unassigned   Actions
        16.
        MV fails for queries with subqueries Sub-task Open Unassigned   Actions
        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
        Actions
        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
        Actions

          Activity

          $i18n.getText('security.level.explanation', $currentSelection) Viewable by All Users
          Cancel

            People

              Dates

              • Created:
                Updated:

              Time Tracking

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

                Issue deployment