[ 
https://issues.apache.org/jira/browse/HIVE-14866?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jesus Camacho Rodriguez updated HIVE-14866:
-------------------------------------------
    Summary: Remove logic to set global limit from SemanticAnalyzer  (was: Set 
hive.limit.optimize.enable to true by default)

> Remove logic to set global limit from SemanticAnalyzer
> ------------------------------------------------------
>
>                 Key: HIVE-14866
>                 URL: https://issues.apache.org/jira/browse/HIVE-14866
>             Project: Hive
>          Issue Type: Improvement
>    Affects Versions: 2.1.0
>            Reporter: Jesus Camacho Rodriguez
>            Assignee: Jesus Camacho Rodriguez
>         Attachments: HIVE-14866.patch
>
>
> Currently, we set up the global limit for the query in two different places 
> through two different variables: SemanticAnalyzer and through an optimization 
> rule GlobalLimitOptimizer (the latest is off by default).
> This leads to several problems that I have observed:
> - Some optimizations are not checking both variables, thus missing 
> opportunities.
> - The variable set by SemanticAnalyzer does not take into account offset of 
> the query, which I think might lead to incorrect results if FetchOptimizer 
> kicks in (not verified yet). GlobalLimitOptimizer does take into account 
> offset of query.
> This issue is to set hive.limit.optimize.enable to _true_ by default, i.e., 
> use GlobalLimitOptimizer, and thus getting rid of the variable set by 
> SemanticAnalyzer. Maybe there are some gaps (cases covered by 
> SemanticAnalyzer alternative and not covered by GlobalLimitOptimizer) that we 
> will need to work on.



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

Reply via email to