phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Wong (Jira)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-5997) Phoenix Explain Plan for Deletes does not clearly differentiate between server side and client side paths.
Date Fri, 10 Jul 2020 19:30:00 GMT

     [ https://issues.apache.org/jira/browse/PHOENIX-5997?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Daniel Wong updated PHOENIX-5997:
---------------------------------
    Description: 
Phoenix Explain Plan for Deletes does not clearly differentiate between server side and client
side paths.  

Currently a server side and client side delete explain plans look like:

  was:
Phoenix Explain Plan for Deletes does not clearly differentiate between server side and client
side paths.  

Original Server Side Delete Explain

DELETE ROWS
CLIENT PARALLEL 1-WAY FULL SCAN OVER ATABLE
 SERVER FILTER BY FIRST KEY ONLY AND ENTITY_ID = 'abc'

New

DELETE ROWS SERVER SELECT
CLIENT PARALLEL 1-WAY FULL SCAN OVER ATABLE
 SERVER FILTER BY FIRST KEY ONLY AND ENTITY_ID = 'abc'

 

Original Client Side Delete Explain 
DELETE ROWS
CLIENT PARALLEL 1-WAY FULL SCAN OVER ATABLE
 SERVER FILTER BY FIRST KEY ONLY AND ENTITY_ID = 'abc'

New

DELETE ROWS CLIENT SELECT
CLIENT PARALLEL 1-WAY FULL SCAN OVER ATABLE
 SERVER FILTER BY FIRST KEY ONLY AND ENTITY_ID = 'abc'

 


> Phoenix Explain Plan for Deletes does not clearly differentiate between server side and
client side paths.
> ----------------------------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-5997
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-5997
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.15.0, 4.16.0
>            Reporter: Daniel Wong
>            Assignee: Daniel Wong
>            Priority: Minor
>             Fix For: 4.16.0
>
>         Attachments: PHOENIX-5997-4.x.patch
>
>          Time Spent: 40m
>  Remaining Estimate: 0h
>
> Phoenix Explain Plan for Deletes does not clearly differentiate between server side and
client side paths.  
> Currently a server side and client side delete explain plans look like:



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message