You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Victoria Markman (JIRA)" <ji...@apache.org> on 2015/04/17 19:41:00 UTC
[jira] [Commented] (DRILL-2148) Wrong result with grouping on a
column of date type with streaming aggregation
[ https://issues.apache.org/jira/browse/DRILL-2148?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14500271#comment-14500271 ]
Victoria Markman commented on DRILL-2148:
-----------------------------------------
Test is running in in above mentioned test, verified with:
{code}
#Wed Apr 15 17:37:25 EDT 2015
git.commit.id.abbrev=cb47df0
{code}
> Wrong result with grouping on a column of date type with streaming aggregation
> ------------------------------------------------------------------------------
>
> Key: DRILL-2148
> URL: https://issues.apache.org/jira/browse/DRILL-2148
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Relational Operators
> Affects Versions: 0.8.0
> Reporter: Victoria Markman
> Assignee: Daniel Barclay (Drill)
> Priority: Critical
> Fix For: 0.8.0
>
> Attachments: 0_0_0.parquet, t1.out, t1.res
>
>
> Disable hash aggregation and run query below:
> {code}
> alter system set `planner.enable_hashagg` = false;
> select
> c_date,
> COUNT(*)
> from t1
> group by
> c_date
> order by
> c_date;
> {code}
> You will get wrong result. Because NULLs are sorted in the middle ( see DRILL-2084 ) they are folded in one of the non related groups.
> We might have the same problem with the merge join on date, time and timestamp columns.
> Attached is a parquet file that was used in this query.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)