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

Propagates filters which are on the join condition transitively

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 0.10.0
    • Fix Version/s: 0.10.0
    • Component/s: Query Processor
    • Labels:
      None
    • Hadoop Flags:
      Reviewed

      Description

      explain select src1.key from src src1 join src src2 on src1.key=src2.key and src1.key < 100;

      In this case, filter on join condition src1.key < 100 can be propagated transitively to src2 by src2.key < 100.

        Attachments

        1. HIVE-3315.D4497.7.patch
          117 kB
          Phabricator
        2. HIVE-3315.D4497.5.patch
          123 kB
          Phabricator
        3. HIVE-3315.D4497.6.patch
          123 kB
          Phabricator
        4. HIVE-3315.3.patch.txt
          98 kB
          Navis
        5. HIVE-3315.2.patch.txt
          97 kB
          Navis
        6. HIVE-3315.1.patch.txt
          59 kB
          Navis

          Activity

            People

            • Assignee:
              navis Navis
              Reporter:
              navis Navis
            • Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: