[jira] [Comment Edited] (HIVE-19690) multi-insert query with multiple GBY, and distinct in only some branches can produce incorrect results

["Sergey Shelukhin (JIRA)" <ji...@apache.org>]

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

Sergey Shelukhin edited comment on HIVE-19690 at 5/24/18 2:53 AM:
------------------------------------------------------------------

[~jcamachorodriguez] [~ashutoshc] can you take a look? 
Without the java changes, the last query in the q file produces incorrect results (regardless of Tez,  vectorization, CBO, etc.).
That is because a list of spray columns (all 3 columns) matches the list of spray+distinct from the other branch, so it creates one RS for two GBY; however, the GBY for v1, v2, v3 has no distinct and is thus not equipped to handle the distinct-specific rows from the RS.


was (Author: sershe):
[~jcamachorodriguez] [~ashutoshc] can you take a look? 
Without the java changes, the last query in the q file produces incorrect results (regardless of Tez,  vectorization, CBO, etc.).


> multi-insert query with multiple GBY, and distinct in only some branches can produce incorrect results
> ------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-19690
>                 URL: https://issues.apache.org/jira/browse/HIVE-19690
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Riju Trivedi
>            Assignee: Sergey Shelukhin
>            Priority: Major
>         Attachments: HIVE-19690.patch
>
>




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