[
https://issues.apache.org/jira/browse/DRILL-5095?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15901955#comment-15901955
]
Chunhui Shi commented on DRILL-5095:
------------------------------------
The provided query is not valid, FULL JOIN works fine in my test. close this
JIRA for now. If needs to reopen please open with accurate repro steps.
> Selecting Join Columns returning null values in the second column
> -----------------------------------------------------------------
>
> Key: DRILL-5095
> URL: https://issues.apache.org/jira/browse/DRILL-5095
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.8.0
> Reporter: Ravan
>
> select a.empno,a.ename,a.deptno,b.deptno deptno deptno_1,b.loc from emp a
> FULL JOIN dept b ON a.deptno = b.deptno
> Returning O/P:-
> empno ename deptno deptno_1 loc
> 7369.0 SMITH 20.0 null DALLAS
> 7499.0 ALLEN 30.0 null CHICAGO
> Estimated O/P:-
> empno ename deptno deptno_1 loc
> 7369.0 SMITH 20.0 20.0 DALLAS
> 7499.0 ALLEN 30.0 30.0 CHICAGO
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
