You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Dony Dong (JIRA)" <ji...@apache.org> on 2018/12/29 11:59:00 UTC
[jira] [Created] (DRILL-6938) SQL get the wrong result after
hashjoin and hashagg disabled
Dony Dong created DRILL-6938:
--------------------------------
Summary: SQL get the wrong result after hashjoin and hashagg disabled
Key: DRILL-6938
URL: https://issues.apache.org/jira/browse/DRILL-6938
Project: Apache Drill
Issue Type: Bug
Affects Versions: 1.13.0
Reporter: Dony Dong
Hi Team
After we disable hashjoin and hashagg to fix out of memory issue, we got the wrong result.
With these two parameters enabled, we will get 8 rows. After we disable them, it only return 3 rows. It seems some MEM_ID had exclude before group or some other step.
select b.MEM_ID,count(distinct b.DEP_NO)
from dfs.test.emp b
where b.DEP_NO<>'-'
and b.MEM_ID in ('68','412','852','117','657','816','135','751')
and b.HIRE_DATE>'2014-06-01'
group by b.MEM_ID
order by 1;
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)