[
https://issues.apache.org/jira/browse/PHOENIX-7936?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andrew Kyle Purtell updated PHOENIX-7936:
-----------------------------------------
Description: Server-side {{UPSERT SELECT}} and {{DELETE}} compile their
inner scan as an aggregating {{SELECT COUNT(1)}} whose count reports how many
rows were touched. Under {{EXPLAIN (VERBOSE)}} that internal rewrite leaked as
a misleading {{PROJECT COUNT(1)}} line (and {{serverProject: ["COUNT(1)"]}} in
JSON) on the inner scan rather than describing the mutation. {{ExplainTable}}
factors the per-scan {{PROJECT}} naming into a reusable static
{{projectedColumnNames(RowProjector)}} and adds
{{{}overrideMutationProject{}}}, which rewrites the {{serverProject}} attribute
with the user-facing projection for {{UPSERT SELECT}} and {{{}DELETE{}}}.
> EXPLAIN the user's projection on server-driven mutation inner plans
> -------------------------------------------------------------------
>
> Key: PHOENIX-7936
> URL: https://issues.apache.org/jira/browse/PHOENIX-7936
> Project: Phoenix
> Issue Type: Sub-task
> Reporter: Andrew Kyle Purtell
> Assignee: Andrew Kyle Purtell
> Priority: Major
> Fix For: PHOENIX-7876-feature
>
>
> Server-side {{UPSERT SELECT}} and {{DELETE}} compile their inner scan as an
> aggregating {{SELECT COUNT(1)}} whose count reports how many rows were
> touched. Under {{EXPLAIN (VERBOSE)}} that internal rewrite leaked as a
> misleading {{PROJECT COUNT(1)}} line (and {{serverProject: ["COUNT(1)"]}} in
> JSON) on the inner scan rather than describing the mutation. {{ExplainTable}}
> factors the per-scan {{PROJECT}} naming into a reusable static
> {{projectedColumnNames(RowProjector)}} and adds
> {{{}overrideMutationProject{}}}, which rewrites the {{serverProject}}
> attribute with the user-facing projection for {{UPSERT SELECT}} and
> {{{}DELETE{}}}.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
