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