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

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.5.0
    • None
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: