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

Phabricator updated HIVE-5560:
------------------------------

    Attachment: D13599.1.patch

navis requested code review of "HIVE-5560 [jira] Hive produces incorrect 
results on multi-distinct query".

Reviewers: JIRA

HIVE-5560 Hive produces incorrect results on multi-distinct query

select key, count(distinct key) + count(distinct value) from src tablesample 
(10 ROWS) group by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
165 1
val_165 1
238 1
val_238 1
255 1
val_255 1
27  1
val_27  1
278 1
val_278 1
311 1
val_311 1
409 1
val_409 1
484 1
val_484 1
86  1
val_86  1
98  1
val_98  1

TEST PLAN
  EMPTY

REVISION DETAIL
  https://reviews.facebook.net/D13599

AFFECTED FILES
  ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
  ql/src/test/queries/clientpositive/groupby2_map_multi_distinct.q
  ql/src/test/results/clientpositive/auto_join18_multi_distinct.q.out
  ql/src/test/results/clientpositive/count.q.out
  ql/src/test/results/clientpositive/groupby2_map_multi_distinct.q.out
  ql/src/test/results/clientpositive/groupby2_noskew_multi_distinct.q.out
  ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out
  ql/src/test/results/clientpositive/groupby_multi_single_reducer.q.out
  ql/src/test/results/clientpositive/groupby_ppr_multi_distinct.q.out
  ql/src/test/results/clientpositive/groupby_sort_11.q.out
  ql/src/test/results/clientpositive/join18_multi_distinct.q.out

MANAGE HERALD RULES
  https://reviews.facebook.net/herald/view/differential/

WHY DID I GET THIS EMAIL?
  https://reviews.facebook.net/herald/transcript/40725/

To: JIRA, navis


> Hive produces incorrect results on multi-distinct query
> -------------------------------------------------------
>
>                 Key: HIVE-5560
>                 URL: https://issues.apache.org/jira/browse/HIVE-5560
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.11.0, 0.12.0
>            Reporter: Vikram Dixit K
>            Assignee: Navis
>         Attachments: D13599.1.patch
>
>
> {noformat}
> select key, count(distinct key) + count(distinct value) from src tablesample 
> (10 ROWS) group by key
> POSTHOOK: type: QUERY
> POSTHOOK: Input: default@src
> #### A masked pattern was here ####
> 165 1
> val_165 1
> 238 1
> val_238 1
> 255 1
> val_255 1
> 27  1
> val_27  1
> 278 1
> val_278 1
> 311 1
> val_311 1
> 409 1
> val_409 1
> 484 1
> val_484 1
> 86  1
> val_86  1
> 98  1
> val_98  1
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.1#6144)

Reply via email to