Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-17039 Implement optimization rewritings that rely on database SQL constraints
  3. HIVE-17044

Transform LEFT/RIGHT OUTER into INNER join in the presence of FK relationship

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 3.0.0
    • 4.0.0-alpha-1
    • Logical Optimizer
    • None

    Description

      Consider we are executing a LEFT OUTER join on two tables using their FK-UK/PK relationship. We might be able to transform the OUTER into an INNER join if the FK columns (OUTER relationship) are not nullable. Similarly for RIGHT OUTER join.

      Attachments

        Issue Links

          is part of

          Sub-task - The sub-task of the issue HIVE-17040 Join elimination in the presence of FK relationship

          • Major - Major loss of function.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: