| --! qt:disabled:flaky HIVE-24112 |
| --! qt:dataset:src |
| set hive.explain.user=false; |
| set hive.tez.dynamic.partition.pruning=true; |
| set hive.tez.dynamic.semijoin.reduction=true; |
| set hive.tez.bigtable.minsize.semijoin.reduction=1; |
| set hive.tez.min.bloom.filter.entries=1; |
| |
| create table dynamic_semijoin_reduction_on_aggcol(id int, outcome string, eventid int) stored as orc; |
| insert into dynamic_semijoin_reduction_on_aggcol select key, value, key from src; |
| |
| explain select a.id, b.outcome from (select id, max(eventid) as event_id_max from dynamic_semijoin_reduction_on_aggcol where id = 0 group by id) a |
| LEFT OUTER JOIN dynamic_semijoin_reduction_on_aggcol b |
| on a.event_id_max = b.eventid; |
| |
| select a.id, b.outcome from (select id, max(eventid) as event_id_max from dynamic_semijoin_reduction_on_aggcol where id = 0 group by id) a |
| LEFT OUTER JOIN dynamic_semijoin_reduction_on_aggcol b |
| on a.event_id_max = b.eventid; |