James Taylor created PHOENIX-3905:
-------------------------------------
Summary: Allow dynamic filtered join queries in UPSERT SELECT to
be distributed across cluster
Key: PHOENIX-3905
URL: https://issues.apache.org/jira/browse/PHOENIX-3905
Project: Phoenix
Issue Type: Improvement
Reporter: James Taylor
Joins on the leading part of the primary key end up doing batches of point
queries (as opposed to a broadcast hash join), and thus could be distributed
across the cluster to improve performance when used in an UPSERT SELECT. The
explain plan of these indicate that a dynamic filter will be performed like
this:
{code}
DYNAMIC SERVER FILTER BY (DML.PK1 DML.PK2, DML.PK3)
IN ((COM.PK1, COM.PK2, COM.PK3))
{code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
