Hive
  1. Hive
  2. HIVE-1252

Task breaking bug when breaking after a filter operator

    Details

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

      Description

      The plan for this query has a bug,
      SELECT f.key, g.value FROM srcpart f JOIN srcpart m ON( f.key = m.key AND f.ds='2008-04-08' AND m.ds='2008-04-08' ) JOIN srcpart g ON(g.value = m.value AND g.ds='2008-04-08' AND m.ds='2008-04-08');
      The first file sink operator's table desc contains all columns.

      1. hive-1252.1.patch
        515 kB
        He Yongqiang
      2. hive-1252.2.patch
        249 kB
        He Yongqiang
      3. hive-1252.3.patch
        250 kB
        He Yongqiang

        Activity

        Hide
        Namit Jain added a comment -

        Can you reduce the test data size - I mean create a new table with fewer rows - or you can use src1 to show the same problem

        Show
        Namit Jain added a comment - Can you reduce the test data size - I mean create a new table with fewer rows - or you can use src1 to show the same problem
        Hide
        He Yongqiang added a comment -

        A new patch integrated Namit's comments. Thanks Namit!

        Show
        He Yongqiang added a comment - A new patch integrated Namit's comments. Thanks Namit!
        Hide
        Namit Jain added a comment -

        Can you change the test to add:

        m.value is not null in the second join - it is painful to verify the results.

        Show
        Namit Jain added a comment - Can you change the test to add: m.value is not null in the second join - it is painful to verify the results.
        Hide
        He Yongqiang added a comment -

        a new patch added m.value is not null and m.value!=''

        Show
        He Yongqiang added a comment - a new patch added m.value is not null and m.value!=''
        Hide
        Namit Jain added a comment -

        Committed. Thanks Yongqiang

        Show
        Namit Jain added a comment - Committed. Thanks Yongqiang

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development