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

mapjoin sometimes gives wrong results if there is a filter in the on condition

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 0.10.0
    • 0.10.0
    • None
    • None
    • Reviewed

    Description

      "SELECT / * + mapjoin(src1, src2) * / * FROM src src1 RIGHT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value;" will give wrong results in today's hive

      Attachments

        1. HIVE-2101.1.patch.txt
          13 kB
          Navis Ryu

        Activity

          People

            navis Navis Ryu
            he yongqiang He Yongqiang
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: