Ravan created DRILL-5095: ---------------------------- Summary: 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.4#6332)