[ 
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)

Reply via email to