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

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

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

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)