hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Navis (JIRA)" <>
Subject [jira] [Commented] (HIVE-5657) TopN produces incorrect results with count(distinct)
Date Mon, 28 Oct 2013 01:39:30 GMT


Navis commented on HIVE-5657:

Yes, top-n is not working with distincts. Test included in limit_pushdown.q was not good enough
to show the flaw. I'll check this later.

> TopN produces incorrect results with count(distinct)
> ----------------------------------------------------
>                 Key: HIVE-5657
>                 URL:
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Sergey Shelukhin
>            Priority: Critical
>         Attachments: example.patch
> Attached patch illustrates the problem.
> limit_pushdown test has various other cases of aggregations and distincts, incl. count-distinct,
that work correctly (that said, src dataset is bad for testing these things because every
count, for example, produces one record only), so something must be special about this.
> I am not very familiar with distinct- code and these nuances; if someone knows a quick
fix feel free to take this, otherwise I will probably start looking next week. 

This message was sent by Atlassian JIRA

View raw message