pxf icon indicating copy to clipboard operation
pxf copied to clipboard

Published 20 hours ago • verified publisher icon greenplum-db

Allow IN operators in JDBC plugin

Open i-amikron opened this issue 3 years ago • 2 comments
trafficstars

Hello!

As we see in SQLQueryBuilder.java, "IN" predicate is commented.

Can we uncomment this row and allow PXF to push down IN predicate into the source system? And if we can't, what's the reason of this limitation?

Thanks!

i-amikron avatar Aug 31 '22 14:08 i-amikron

Hi! Can we expect any information on this issue?

i-amikron avatar Oct 17 '22 08:10 i-amikron

Hi!

We are not aware of any reasons why the "IN" predicate is commented out. However, we'd prefer to not uncomment it and release it without proper testing as a missing optimization is preferable to incorrect results.

That being said, we currently do not have plans to work on this due to other priorities. If you would like to work on this, we always welcome a PR with appropriate test coverage.

ashuka24 avatar Oct 18 '22 21:10 ashuka24