lucusguo created HIVE-24285:
-------------------------------
Summary: 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
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
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)
