You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Ravan (JIRA)" <ji...@apache.org> on 2016/12/02 07:24:59 UTC

[jira] [Created] (DRILL-5095) Selecting Join Columns returning null values in the second column

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)