[
https://issues.apache.org/jira/browse/HIVE-9112?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14283395#comment-14283395
]
Ashutosh Chauhan commented on HIVE-9112:
----------------------------------------
committed to 0.14 branch
> Query may generate different results depending on the number of reducers
> ------------------------------------------------------------------------
>
> Key: HIVE-9112
> URL: https://issues.apache.org/jira/browse/HIVE-9112
> Project: Hive
> Issue Type: Bug
> Components: Logical Optimizer
> Affects Versions: 0.14.0
> Reporter: Chao
> Assignee: Ted Xu
> Fix For: 0.15.0, 0.14.1
>
> Attachments: HIVE-9112-0.14.1-branch.patch, HIVE-9112.1.patch,
> HIVE-9112.2.patch, HIVE-9112.patch
>
>
> Some queries may generate different results depending on the number of
> reducers, for example, tests like ppd_multi_insert.q, join_nullsafe.q,
> subquery_in.q, etc.
> Take subquery_in.q as example, if we add
> {noformat}
> set mapred.reduce.tasks=3;
> {noformat}
> to this test file, the result will be different (and wrong):
> {noformat}
> @@ -903,5 +903,3 @@ where li.l_linenumber = 1 and
> POSTHOOK: type: QUERY
> POSTHOOK: Input: default@lineitem
> #### A masked pattern was here ####
> -108570 8571
> -4297 1798
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
