[
https://issues.apache.org/jira/browse/DRILL-5095?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Chunhui Shi closed DRILL-5095.
------------------------------
Resolution: Works for Me
> 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)
