[jira] [Resolved] (DRILL-456) Inconsistent results between Hive and Drill (an extra row appeared in Drill)

["Jacques Nadeau (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-456?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Nadeau resolved DRILL-456.
----------------------------------

    Resolution: Fixed

Fixed in 9d7bb06

> Inconsistent results between Hive and Drill (an extra row appeared in Drill)
> ----------------------------------------------------------------------------
>
>                 Key: DRILL-456
>                 URL: https://issues.apache.org/jira/browse/DRILL-456
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Neeraja
>            Assignee: Aman Sinha
>         Attachments: 0001-Fix-Drill-456-extra-row-in-the-output-of-grouped-agg.patch
>
>
> Tried a simple query as below.
> The results look different between Hive and Drill (note the extra result row in case of Drill)
> Query:
> select l_returnflag,l_linestatus, count(*)  from lineitem  group by l_returnflag, l_linestatus order by l_returnflag,l_linestatus;
> Hive results:
> A	F	147790
> N	F	3765
> N	O	300716
> R	F	148301
> Drill results:
> +------------+--------------+--------------+
> |   EXPR$2   | l_returnflag | l_linestatus |
> +------------+--------------+--------------+
> | 147790     | A            | F            |
> | 3765       | N            | F            |
> | 0          | N            | O            |
> | 300716     | N            | O            |
> | 148301     | R            | F            |
> +------------+--------------+--------------+



--
This message was sent by Atlassian JIRA
(v6.2#6252)