search

prestodb / presto

The official home of the Presto distributed SQL query engine for big data
http://prestodb.io
Apache License 2.0
15.89k stars 5.32k forks source link

Implement JOIN pushdown for JDBC connectors #16597

Open wypb opened 3 years ago

wypb commented 3 years ago

Currently, Trino's JDBC supports Join pushdown. Join pushdown allows the connector to delegate the table join operation to the underlying data source, This can result in performance gains.

A few days ago, we have submitted an MR that supports join pushdown to the Presto community. With this mr, we can also implement join pushdown.

gavincilp commented 3 years ago

how about to add some kind of hint to tell presto push whole with clause to datasource . and get the resultset back to participate next stage