You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Jesus Camacho Rodriguez (Jira)" <ji...@apache.org> on 2020/06/18 20:10:00 UTC

[jira] [Commented] (HIVE-23723) Limit operator pushdown through LOJ

    [ https://issues.apache.org/jira/browse/HIVE-23723?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17139971#comment-17139971 ] 

Jesus Camacho Rodriguez commented on HIVE-23723:
------------------------------------------------

[~amagyar], this is available through CBO ({{hive.optimize.limittranspose}}). Should we enable that rule instead of implementing a new transformation rule on the Hive side?

> Limit operator pushdown through LOJ
> -----------------------------------
>
>                 Key: HIVE-23723
>                 URL: https://issues.apache.org/jira/browse/HIVE-23723
>             Project: Hive
>          Issue Type: Improvement
>          Components: Hive
>            Reporter: Attila Magyar
>            Assignee: Attila Magyar
>            Priority: Major
>             Fix For: 4.0.0
>
>         Attachments: HIVE-23723.1.patch
>
>
> Limit operator (without an order by) can be pushed through SELECTS and LEFT OUTER JOINs.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)