Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-4196

some TPCDS queries return wrong result when hash join is disabled

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.5.0
    • Component/s: None
    • Labels:
      None

      Description

      With hash join disabled query52.sql and query40.sql returned incorrect result with 1.4.0 :

      +-----------------+-------------------------------------------+---------------------------------------------------------------------+----------------------------+--------------+----------------------------+
      |     version     |                 commit_id                 |                           commit_message                            |        commit_time         | build_email  |         build_time         |
      +-----------------+-------------------------------------------+---------------------------------------------------------------------+----------------------------+--------------+----------------------------+
      | 1.4.0-SNAPSHOT  | b9068117177c3b47025f52c00f67938e0c3e4732  | DRILL-4165 Add a precondition for size of merge join record batch.  | 08.12.2015 @ 01:25:34 UTC  | Unknown      | 08.12.2015 @ 03:36:25 UTC  |
      +-----------------+-------------------------------------------+---------------------------------------------------------------------+----------------------------+--------------+----------------------------+
      1 row selected (2.13 seconds)
      

      Setup and options are the same as in DRILL-4190

      See attached queries (.sql), expected result (.e_tsv) and actual output (.out)

        Attachments

        1. 1.5.0-amit-branch_tpcds_sf1.txt
          4 kB
          Victoria Markman
        2. query40.tar
          13 kB
          Victoria Markman
        3. query52.tar
          12 kB
          Victoria Markman

          Issue Links

            Activity

              People

              • Assignee:
                aah amit hadke
                Reporter:
                vicky Victoria Markman
                Reviewer:
                Victoria Markman
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: