[ 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)