drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chunhui Shi (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (DRILL-5095) Selecting Join Columns returning null values in the second column
Date Wed, 08 Mar 2017 20:55:38 GMT

     [ 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)

Mime
View raw message