Top-N pushdown support for the MongoDB connector

[cbartosiak]

It would be great to add support for Top-N pushdown in the MongoDB connector.

Right now, even simple queries like:

SELECT * FROM "mongo"."db"."coll" ORDER BY "x" LIMIT 25

do not benefit from MongoDB's native .sort().limit() optimization.

Pushing this down would improve performance and reduce unnecessary data transfer.

[dhruvbajpai29]

Hi @cbartosiak, @ebyhr,

I’d like to work on adding Top-N pushdown support for the MongoDB connector. I plan to implement applyTopN in MongoMetadata.java to translate ORDER BY ... LIMIT N into MongoDB’s .sort().limit().

Is this issue still open? Could you assign it to me. I’ll start by setting up the Trino dev environment and exploring the MongoDB connector code.

Thanks.

[ebyhr]

@dhruvbajpai29 Please feel free to send a PR without assignment.

[codluca]

Created pull request
#26504

[codluca]

@ebyhr Hi, are there any issues with the pull request?