Hive
  1. Hive
  2. HIVE-560

column pruning not working with map joins

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 0.4.0
    • Fix Version/s: 0.4.0
    • Component/s: Query Processor
    • Labels:
      None
    • Hadoop Flags:
      Reviewed

      Description

      drop table tst1;
      drop table tst2;

      create table tst1(a1 string, a2 string, a3 string, a4 string);
      create table tst2(b1 string, b2 string, b3 string, b4 string);

      explain select /*+ MAPJOIN(a) */ a.a1, a.a2 from tst1 a join tst2 b ON a.a2=b.b2;

      the select is after the join - column pruning is not happening

      1. hive-560-2009-06-19-2.patch
        27 kB
        He Yongqiang
      2. hive-560-2009-06-19-5.patch
        204 kB
        He Yongqiang
      3. hive-560-2009-06-24-mapjoin-before-column-pruning.patch
        267 kB
        He Yongqiang
      4. hive-560-2009-06-24-normal(mapjoin-after-column-pruning).patch
        272 kB
        He Yongqiang
      5. hive-560-2009-06-25.patch
        271 kB
        He Yongqiang

        Issue Links

          Activity

          No work has yet been logged on this issue.

            People

            • Assignee:
              He Yongqiang
              Reporter:
              Namit Jain
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development