You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Navis (JIRA)" <ji...@apache.org> on 2014/07/14 03:51:04 UTC

[jira] [Created] (HIVE-7398) Parent GBY of MUX is removed even it's not for semijoin

Navis created HIVE-7398:
---------------------------

             Summary: Parent GBY of MUX is removed even it's not for semijoin
                 Key: HIVE-7398
                 URL: https://issues.apache.org/jira/browse/HIVE-7398
             Project: Hive
          Issue Type: Sub-task
          Components: Query Processor
            Reporter: Navis
            Assignee: Navis


{code}
set hive.optimize.correlation=true;

explain
select b.key, count(*) 
from src b 
group by b.key
having exists 
  (select a.key 
  from src a 
  where a.key = b.key and a.value > 'val_9'
  );
{code}
One of the parent of Mux is final type GBY, but it's regarded as one for semi-join and removed.



--
This message was sent by Atlassian JIRA
(v6.2#6252)