, September 13, 2013 6:05 AM
*To:* user@hive.apache.org
*Subject:* Re: 回复: hive 0.11 auto convert join bug report
** **
Hi Navis,
** **
I was trying to look at this email thread as well as the jira to
understand the scope of this issue. Does this get triggered only in cases
of using
the copy of Mapredwork in the case of noconditionaltask optimization was
optimized off.
** **
** **
*From:* Amit Sharma [mailto:amsha...@netflix.com]
*Sent:* Friday, September 13, 2013 6:05 AM
*To:* user@hive.apache.org
*Subject:* Re: 回复: hive 0.11 auto convert join bug report
To: user@hive.apache.org
Subject: Re: 回复: hive 0.11 auto convert join bug report
Hi Navis,
I was trying to look at this email thread as well as the jira to understand the
scope of this issue. Does this get triggered only in cases of using aliases
which end up mapping to the same value upon hashing
Hi, sorry for late reply.
As Chun Chen said, same hashcode would make this problem vivid. But it can
be happened whenever the appearing order in JOIN expression is different
with that of parents.
Thanks.
2013/9/13 Amit Sharma amsha...@netflix.com
Hi Navis,
I was trying to look at this
Hi Navis,
I was trying to look at this email thread as well as the jira to understand
the scope of this issue. Does this get triggered only in cases of using
aliases which end up mapping to the same value upon hashing? Or can this be
triggered under other conditions as well? What if the aliases
Hi all:
when I change the table alias dim_pay_date to A, the query pass in hive
0.11(https://gist.github.com/code6/6187569#file-hive11_auto_convert_join_change_alias_pass):
use test;
create table if not exists src ( `key` int,`val` string);
load data local inpath
Hi,
I've booked this on https://issues.apache.org/jira/browse/HIVE-5056
and attached patch for it.
It needs full test for confirmation but you can try it.
Thanks.
2013/8/11 wzc1...@gmail.com:
Hi all:
when I change the table alias dim_pay_date to A, the query pass in hive
Hi,
Hive is notorious making different result with different aliases.
Changing alias was a final way to avoid bug in desperate situation.
I think the patch in the issue is ready, wish it's helpful.
Thanks.
2013/8/11 wzc1...@gmail.com:
Hi Navis,
My colleague chenchun finds that hashcode of