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

Posted to issues@hive.apache.org by "lucusguo (Jira)" <ji...@apache.org> on 2020/10/19 11:02:00 UTC

[jira] [Assigned] (HIVE-24285) GlobalLimitOptimizer not working

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

lucusguo reassigned HIVE-24285:
-------------------------------


> GlobalLimitOptimizer not working
> --------------------------------
>
>                 Key: HIVE-24285
>                 URL: https://issues.apache.org/jira/browse/HIVE-24285
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 3.1.2, 2.0.1
>            Reporter: lucusguo
>            Assignee: Jesus Camacho Rodriguez
>            Priority: Critical
>         Attachments: image-2020-10-19-18-59-05-302.png, image-2020-10-19-19-00-05-123.png, image-2020-10-19-19-00-23-487.png
>
>   Original Estimate: 504h
>  Remaining Estimate: 504h
>
> In our environment，we have set hive.limit.optimize.enable=true,hive.limit.row.max.size=10000000,hive.limit.optimize.fetch.max=1000,hive.fetch.task.conversion.threshold=256000000000000,hive.fetch.task.conversion=more,hive.auto.convert.join=true
> when we execute the sql like this,GlobalLimitOptimizer not working.
> select db_name,concat('22',cnt) from (select * from lb1 limit 5) t1;
> because in this sql there is one LimitOperator, but logs count 2
> the code and logs below
>  
> !image-2020-10-19-19-00-23-487.png!
>  
> !image-2020-10-19-19-00-05-123.png!
>  



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