Does PolyBase support JOIN PUSHDOWN to Oracle Data Source

Question

From my testing PolyBase on SQL 2019 does not push JOIN to the data source, even though the data source is setup with PUSH DOWN on.

The documentation it states JOINS can be pushed down to Oracle.

https://learn.microsoft.com/en-us/sql/relational-databases/polybase/polybase-pushdown-computation?view=sql-server-ver15

Is there some setting I might be missing that would prevent the JOIN push.

Thanks,

Mihaela

Answer 1

In order to answer that, we need to see what is your setup and what is your query. According to the documentation, the syntax or some functions can prevent pushdown.