drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Victoria Markman (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-2148) Wrong result with grouping on a column of date type with streaming aggregation
Date Fri, 17 Apr 2015 17:41:00 GMT

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

Mime
View raw message