Question about Peak Memory Usage of "Order By" with Partitioning

[osy497]

Hello, I'm using trino and have a question.

I have a table with stored data which is partitioned by hourly logTime and am using Iceberg table and REST Catalog.

I want to execute the query into below table like :

create table if not exists sample_1month with (
    location = 's3a://1month',
    format = 'PARQUET',
    partitioning = ARRAY['hour(logtime)']
)
as select * from sample_1month where data.logtime >= from_iso8601_timestamp('2024-09-01T00:00:00.000000') AND logtime <= from_iso8601_timestamp('2024-09-30T00:00:00.000000') order by logtime;

I think partitioning of base table can significantly reduce memory usage because sorting only on partitioned data becomes full sorting, am I right?