zhikunwu

Hi @ebyhr and @ysn2233 , I see the PR14925 was closed last week . I have already compared the differences between these two PRs. The main difference is whether to...

> the closed one was moved to #20759 OK, Thanks. I just found it.

I also run this test on trino 383, the same sql and data. The live plan is  

presto analyze: [presto.txt](https://github.com/prestodb/presto/files/8841969/presto.txt) trino analzye: [trino.txt](https://github.com/prestodb/presto/files/8841970/trino.txt)

https://github.com/prestodb/presto/pull/17849 there is a pull request for this，but after merged this pr，hive connector still has this issue。 [trino384_hive_plan.txt](https://github.com/prestodb/presto/files/8887723/trino384_hive_plan.txt) [presto273_hive_plan.txt](https://github.com/prestodb/presto/files/8887724/presto273_hive_plan.txt)