You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@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)