Hive
  1. Hive
  2. HIVE-3315

Propagates filters which are on the join condition transitively

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Minor 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.

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

        Activity

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development