Maksym Rymar created DRILL-8513:
-----------------------------------

             Summary: Right Hash Join with empty Left table ruturns 0 result
                 Key: DRILL-8513
                 URL: https://issues.apache.org/jira/browse/DRILL-8513
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Maksym Rymar
            Assignee: Maksym Rymar


Drill returns no results on the right Hash Join if the probe(left) table is 
empty.

The simplest way to reproduce the issue:
 # To force Drill not to use merge join and use the hash join operator instead:

{code:java}
alter session set planner.enable_mergejoin = false;
alter session set planner.enable_nestedloopjoin= false;{code}

 # Disable join order optimization to prevent Drill from flipping join tables:
{code:java}
alter session set planner.enable_join_optimization = false; {code}

 # Execute a query with empty left table outcome:

{code:java}
SELECT *
FROM 
    (SELECT * FROM (VALUES (1, 'Max', 28), 
                           (2, 'Jane', 32),
                           (3, 'Saymon', 29)
                   ) AS users(id, name, age)
    WHERE false
    ) AS users
RIGHT JOIN 
    (VALUES (1, 'Engineer'), 
            (2, 'Doctor'), 
            (3, 'Teacher')
    ) AS job(id, title)
ON users.id = job.id {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to