Uploaded image for project: 'Apache HAWQ'
  1. Apache HAWQ
  2. HAWQ-1616

Wrong Result of Hash Join When Enable Bloom filter

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 2.4.0.0
    • Query Execution
    • None

    Description

      Wrong result of Hash Join when enable Bloom filter in some cases, e.g join key "l_partkey" is not in select list:

      select l_quantity, l_partkey, l_extendedprice from part, lineitem where p_partkey = l_partkey and p_brand = 'Brand#23' and p_container = 'MED BOX' limit 10;

      select l_quantity, l_extendedprice from part, lineitem where p_partkey = l_partkey and p_brand = 'Brand#23' and p_container = 'MED BOX' limit 10;

      The SQL statement and data are from TPCH workload, the correct result should be:
      l_quantity | l_extendedprice
      -----------+----------------
      3.00 | 5399.55
      6.00 | 8318.58
      38.00 | 57927.20
      49.00 | 90545.63
      44.00 | 76197.88
      10.00 | 17146.20
      26.00 | 34376.94
      35.00 | 56332.85
      9.00 | 11999.88
      14.00 | 24020.92
      (10 rows)

      The projection information hasn't been pushed down to parquet scan correctly, so current result is none.

      Attachments

        Issue Links

          Activity

            People

              wlin Wen Lin
              wlin Wen Lin
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: