I'm almost dropping Trino and trying PrestoDB instead. If that doesn't work either, I'll have to brute-force this thing and rely on implementing the joins myself.

Thanks @User. keep us posted. @User would be good to chat with Diogo to get his feedback on trino-pinot connector. I know we chatted about not having the need of dynamic tables.

Thanks! 🙂

Yes, we do have a workaround but it may be very hacky - I can share more details if the dynamic table doesn't work.

Got it. Thanks @User, I'm doing some changes to see if push-down through dynamic tables works fine.