[jira] [Created] (PHOENIX-3905) Allow dynamic filtered join queries in UPSERT SELECT to be distributed across cluster

["James Taylor (JIRA)" <ji...@apache.org>]

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)