Francisco Guerrero

@LittleWuCoding looking at your query I realize that you are doing a join. PXF does not support join pushdown (yet), but we are working on adding performance features for PXF....

> ``` > select a.xxx, b.yyy from a join b where a.aa = b.bb and a.cc = qqq; > ``` Out of curiosity, can you share the explain plan for...

It looks like vertica is rejecting some rows, and the transaction will fail as a consequence. Maybe check in the vertica logs to see what rows are being rejected.

Thanks for the review @ekaterinadimitrova2 and @yifan-c . I think this PR is in a good place for merging.

@mp911de I'd like to contribute this feature. Let me know if no one has picked it up already.

@vietj Done, I'm also generating the test files dynamically for each test.

I will provide a patch for `master` shortly.

I found a couple additional issues that I will address shortly. They've been fixed for the PR against `master`