You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org> on 2016/12/20 11:58:58 UTC

[jira] [Created] (HIVE-15474) Extend limit propagation for chain of RS-GB-RS operators

Jesus Camacho Rodriguez created HIVE-15474:
----------------------------------------------

             Summary: Extend limit propagation for chain of RS-GB-RS operators
                 Key: HIVE-15474
                 URL: https://issues.apache.org/jira/browse/HIVE-15474
             Project: Hive
          Issue Type: Bug
    Affects Versions: 2.2.0
            Reporter: Jesus Camacho Rodriguez
            Assignee: Jesus Camacho Rodriguez


The goal is to extend the work started in HIVE-14002.

For instance, given the following query:

{code:sql}
explain
select key, value, count(key + 1) as agg1 from src 
group by key, value
order by key, value, agg1 limit 20;
{code:sql}

We can push the limit to the GBy operator. However, currently we do not do it.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)