Iceberg Query with equality sign filter stuck in the planning stage

[netanelm-upstream]

I have a query that is stuck in the planning stage:

select
    column_1
from table
where processing_time >= timestamp '2023-05-10 01:00:00'
and processing_time <= timestamp '2023-05-10 05:00:00';

It's working if:

• Using only one condition.
• Using one side without an equality sign (the bug is only if I use <= and >=)
• using the same query but different filter functions:

  
  where date_trunc('day', processing_time) = current_date 
  and extract(hour from processing_time) between 1 and 5;

processing_time is a partition column hour(processing_time)

Column type:
`processing_time timestamp(6)`

Using iceberg, tested with Hive Metastore and JDBC catalog.
Trino Version 407.
Noticed that on trino version 394 it also working.

Slack channel:
https://trinodb.slack.com/archives/CJ6UC075E/p1683717204698349

[findepi]

stuck in the planning stage:

can you capture thread dumps and see where the planner is being busy?

[netanelm-upstream]

@findepi How can I find the thread dumps? I am running Trino on k8s

[findepi]

@netanelm-upstream this might help https://www.baeldung.com/ops/java-heap-dump-from-kubernetes-pod#getting_heap_dump

[findinpath]

Probably related to https://github.com/trinodb/trino/issues/19266