Trino Hudi connector returning zero records for tables with partition projection enabled

[drautela-scwx]

Trino Hudi connector is returning zero records for tables with partition projection enabled. The connector works fine for tables that don't have partition projection enabled.

We are trying to setup the following in AWS:

Trino on EKS: version 465
HMS: Glue.

Queries for Hudi table with partition projection enabled is returning zero records with no errors.

Trino Hudi connector is working fine for Hudi tables that don't have partition projection enabled.

We have both Hive and Hudi connectors setup as follows:

(1) /etc/trino/catalog/awsdatacatalog.properties

connector.name=hive
hive.metastore=glue
hive.hive-views.enabled=true
hive.partition-projection-enabled=true
fs.native-s3.enabled=true
hive.hudi-catalog-name=hudi

(2) /etc/trino/catalog/hudi.properties

connector.name=hudi
hive.metastore=glue
fs.native-s3.enabled=true

Zero records are returned for Hudi tables whether we use awsdatacatalog or hudi catalog

select *
from awsdatacatalog.hudi_db.test_table_ro
where partition1 = "123"
and partition2 = "abc"
limit 10;

select *
from hudi.hudi_db.test_table_ro
where partition1 = "123"
and partition2 = "abc"
limit 10;