Github user twdsilva commented on the issue:
https://github.com/apache/phoenix/pull/358
@geraldss
I tried running your test without the fix and it still passes. The compiler
optimizes the query to use SKIP-SCAN-JOIN so the hash cache is not sent to the
server. The explain plan is
CLIENT PARALLEL 1-WAY FULL SCAN OVER UNSALTED_N000001
SERVER ARRAY ELEMENT PROJECTION
SKIP-SCAN-JOIN TABLE 0
DYNAMIC SERVER FILTER BY UNSALTED_N000001.ID IN ($1.$3)
I will just commit your original PR without the test since it doesn't add
anything.
You can file a separate JIRA to fix ProjectArrayElemAfterHashJoinIT to
actually test HashJoin.
---
