hive-issues mailing list archives

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


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
  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:
>             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

View raw message