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

Transform OUTER join with condition always true into INNER join

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Invalid
    • None
    • None
    • CBO
    • None
    • Hide
      In the case where the outer join side has zero rows, the inner join would contain zero rows whereas the outer join would contain the left side rows.

      Since they are not equivalent, we cannot transform this.
      Show
      In the case where the outer join side has zero rows, the inner join would contain zero rows whereas the outer join would contain the left side rows. Since they are not equivalent, we cannot transform this.

    Description

      For instance, it may help the join reordering algorithm.

      Attachments

        Activity

          People

            scarlin Steve Carlin
            jcamacho Jesús Camacho Rodríguez
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: