You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Chunhui Shi (JIRA)" <ji...@apache.org> on 2017/03/08 20:55:38 UTC
[jira] [Commented] (DRILL-5095) Selecting Join Columns returning
null values in the second column
[ https://issues.apache.org/jira/browse/DRILL-5095?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15901955#comment-15901955 ]
Chunhui Shi commented on DRILL-5095:
------------------------------------
The provided query is not valid, FULL JOIN works fine in my test. close this JIRA for now. If needs to reopen please open with accurate repro steps.
> 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)