[
https://issues.apache.org/jira/browse/HIVE-24285?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jesus Camacho Rodriguez reassigned HIVE-24285:
----------------------------------------------
Assignee: (was: Jesus Camacho Rodriguez)
> 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: 2.0.1, 3.1.2
> Reporter: lucusguo
> 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)
