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)