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

some TPCDS queries return wrong result when hash join is disabled

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          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:

              Slack

                Issue deployment