Hive's performance for querying the Iceberg table is very poor.

[lisoda]

Hi Team.
      I recently was testing Hive query Iceberg table , I found that Hive query 
Iceberg table performance is very very poor . Almost impossible to use in the 
production environment . And Join conditions can not be pushed down to the 
Iceberg partition.
      I'm using the 1.3.1 Hive Runtime Jar from the Iceberg community.
      Currently I'm using Hive 3.1.3, Iceberg 1.3.1. 
      Now I'm very frustrated because the performance is so bad that I can't 
deliver to my customers. How can I solve this problem?
     Details:  
https://apache-iceberg.slack.com/archives/C025PH0G1D4/p1695050248606629
    I would be grateful if someone could guide me.