phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-3905) Allow dynamic filtered join queries in UPSERT SELECT to be distributed across cluster
Date Thu, 01 Jun 2017 22:27:04 GMT
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)

Mime
View raw message