drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ravan (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-5095) Selecting Join Columns returning null values in the second column
Date Fri, 02 Dec 2016 07:24:59 GMT
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)

Mime
View raw message