I looked a bit better on the plans of query2 and query59 and there is
something weird with the semi joins that appear in the plan.
A possible workaround, till we fix the problem, would be to disable semi
joins for these two queries:
set hive.tez.dynamic.semijoin.reduction=false;
Best,
Stamatis
O
Hi Sungwoo,
As far as it concerns query14 the problem is logged in HIVE-24167 [1].
There is also a PR [2] for reproducing the problem so it should be feasible
to find the offending commit with git bisect.
For queries 2 and 59, I am also able to reproduce the behavior that you
mentioned (same redu
