hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Laljo John Pullokkaran (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-11684) Implement limit pushdown through outer join in CBO
Date Tue, 10 Nov 2015 21:48:11 GMT

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

Laljo John Pullokkaran commented on HIVE-11684:
-----------------------------------------------

[~jcamachorodriguez] Could you update RB?
  1. It seems like HiveProjectSortTransposeRule is not checking if sort col is visible above
project.
  2. HiveSortJoinReduceRule: shouldn't it check if sort cols are coming from outer side
  3. HiveSortMergeRule:
                          a) Check to see if input is reduced seems unnecessary; seems like
we should always merge them
                          b) Merge needs to be more sophisticated: what limit will you use
(i would think min of both), what collation to use (both, in the order).


> Implement limit pushdown through outer join in CBO
> --------------------------------------------------
>
>                 Key: HIVE-11684
>                 URL: https://issues.apache.org/jira/browse/HIVE-11684
>             Project: Hive
>          Issue Type: New Feature
>          Components: CBO
>    Affects Versions: 2.0.0
>            Reporter: Jesus Camacho Rodriguez
>            Assignee: Jesus Camacho Rodriguez
>         Attachments: HIVE-11684.01.patch, HIVE-11684.02.patch, HIVE-11684.03.patch, HIVE-11684.04.patch,
HIVE-11684.05.patch, HIVE-11684.07.patch, HIVE-11684.08.patch, HIVE-11684.09.patch, HIVE-11684.10.patch,
HIVE-11684.11.patch, HIVE-11684.12.patch, HIVE-11684.12.patch, HIVE-11684.14.patch, HIVE-11684.15.patch,
HIVE-11684.16.patch, HIVE-11684.patch
>
>




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

Mime
View raw message