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

Zoltan Haindrich commented on HIVE-21923:
-----------------------------------------

disabling auto.convert.join changes the resultset from 0 to 5680 ; for the 
query:
{code}
SELECT COUNT(*)
 FROM src1 x JOIN srcpart z ON (x.key = z.key)
 JOIN srcpart w ON (x.key = w.key)
 JOIN src y ON (y.key = x.key)
{code}
because there is no limit or similar in the above query - I think this means 
that there is bug somewhere...

> Disabling n-way joins caused some resultset changes
> ---------------------------------------------------
>
>                 Key: HIVE-21923
>                 URL: https://issues.apache.org/jira/browse/HIVE-21923
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Zoltan Haindrich
>            Assignee: Zoltan Haindrich
>            Priority: Major
>
> HIVE-21189 have introduced some resultset changes
> in ql/src/test/results/clientpositive/llap/hybridgrace_hashjoin_2.q.out
> https://github.com/apache/hive/commit/5799398450c17d06e8ef144ce835a8524f5abec9#diff-56b3ab96b6c90fdbebe2c4f84e8595afL500



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

Reply via email to