Subquery cache roadmap about trino HOT 5 OPEN

@sopel39 I am interested in contributing to this topic, but I am not very familiar with the tasks mentioned above. Could you guide me on how to start and suggest which task or tasks might be suitable to start

from trino.

Thanks a lot @sopel39 !

We had discussed a couple of times on the old issue about the implementation and approach.

As discussed we were also looking into the same problem, and would be more than happy to contribute.
Please share your thoughts, where do you think I can work on.

May be,

#22116
Or
#22165
Or

Whatsoever task you think.

Thanks.

from trino.

Hi @osscm

Take into consideration that it will probably take some time to land this PR. I'm extracting smaller PRs atm. However, I think we should also progress with the improvements.

#22116 and #22165 are both important. Especially #22116 will improve cache hit rate for string partition types, which are fairy common.

However, I would start with something simpler like #22120 to familiarize with the concepts (code can still change in the process of review)

I would start with something simpler like #22121 to familiarize with the concepts (code can still change in the process of review)

from trino.

Hi @sopel39

I am interested to contribute to this issue. Going through the code and implementation in understanding the issue. Can you please guide me which sub-task I can take up and able to contribute.

from trino.

@sug-ghosh I think we would need to sync. Ping me on slack please

from trino.