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

HiveRemoveSqCountCheck rule could be enhanced to capture more patterns

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 4.0.0
    • None
    • Query Planning
    • None

    Description

      HIVE-21231 caused the pattern of scalar subqueries to change a bit causing HiveRemoveSqCountCheck rule to not kick in anymore.

      Queries for which this has regressed are the ones which contain group by with constant keys. getRelMdMaxRowCount needs to be improved for this to work.
      Ref: CALCITE-2991
       

      Attachments

        1. HIVE-21572.3.patch
          103 kB
          Vineet Garg
        2. HIVE-21572.2.patch
          102 kB
          Vineet Garg
        3. HIVE-21572.1.patch
          102 kB
          Vineet Garg

        Issue Links

          depends upon

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-21231 HiveJoinAddNotNullRule support for range predicates

          • Major - Major loss of function.
          • Closed

          Activity

            People

              vgarg Vineet Garg
              vgarg Vineet Garg
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: