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

HiveRemoveSqCountCheck rule could be enhanced to capture more patterns

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 4.0.0
    • Fix Version/s: None
    • Component/s: Query Planning
    • Labels:
      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

            Activity

              People

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

                Dates

                • Created:
                  Updated: