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

Improve filter condition for correlated subqueries

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 3.0.0
    • None
    • None

    Description

      A filter condition such as col1=col1 generated during rewrite of subqueries is not folded/rewritten into co1 is not null. This messes up the statistic estimation and could result in bad plans.

      Attachments

        1. HIVE-16809.1.patch
          2 kB
          Vineet Garg
        2. HIVE-16809.2.patch
          2 kB
          Vineet Garg
        3. HIVE-16809.3.patch
          2 kB
          Vineet Garg

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: