[jira] [Comment Edited] (HIVE-20988) Wrong results for group by queries with primary key on multiple columns

["Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-20988?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16705176#comment-16705176 ] 

Jesus Camacho Rodriguez edited comment on HIVE-20988 at 11/30/18 7:04 PM:
--------------------------------------------------------------------------

[~vgarg], would you mind creating an issue similar to HIVE-19114 for the query in materialized_view_rewrite_1.q and assign it to me? I will take a look at some point. Thanks


was (Author: jcamachorodriguez):
[~vgarg], would you mind creating an issue similar to https://issues.apache.org/jira/browse/HIVE-19114 for the query in materialized_view_rewrite_1.q and assign it to me? I will take a look at some point. Thanks

> Wrong results for group by queries with primary key on multiple columns
> -----------------------------------------------------------------------
>
>                 Key: HIVE-20988
>                 URL: https://issues.apache.org/jira/browse/HIVE-20988
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 4.0.0
>            Reporter: Vineet Garg
>            Assignee: Vineet Garg
>            Priority: Major
>         Attachments: HIVE-20988.1.patch, HIVE-20988.2.patch
>
>
> If a table has multi column primary key group by optimization ends up removing group by which is semantically incorrect.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)