[DRILL-4196] some TPCDS queries return wrong result when hash join is disabled

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.5.0
• Assignee: amit hadke
• Reporter: Victoria Markman
• Reviewer: Victoria Markman
• Created: 14/Dec/15 18:10
• Updated: 31/May/18 23:39
• Resolved: 28/Jan/16 00:09

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)

Issue Links

• links to: GitHub Pull Request #338