[
https://issues.apache.org/jira/browse/PHOENIX-4585?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16367713#comment-16367713
]
Maryann Xue commented on PHOENIX-4585:
--------------------------------------
{quote}How about adding a UNION ALL test to make sure we're doing the pruning
there too?{quote}
Sure. I'll go ahead add a test.
{quote} - If you want to combine this with PHOENIX-4614, that's fine too if you
think you can get to it soon.{quote}
I don't know exactly what PHOENIX-4614 would take, plus PHOENIX-4614 has little
user impact, so I'll commit this issue first when it's ready.
{quote}What happens in that optimize call for joins & union all (since it seems
that the optimization happens during compile)? Should we clean that up (maybe
in a separate JIRA)?{quote}
Yes, we should pull that "optimize" logic out from compile(). I just opened
PHOENIX-4616. It will be quite an mount of work.
{quote} Also related to the above, we need to ensure that tableRefs returns the
original data tables and not the index tables or we won't send over uncommitted
data when transactions are used. Do you think that's happening?{quote}
Not sure, I'll check. If not, it will either depend on PHOENIX-4616, or for a
quick fix, we can add a "no index" hint to the {{stmt}} here to make sure we
get all data tables. I'll open a JIRA for that either way.
> Prune local index regions used for join queries
> -----------------------------------------------
>
> Key: PHOENIX-4585
> URL: https://issues.apache.org/jira/browse/PHOENIX-4585
> Project: Phoenix
> Issue Type: Improvement
> Reporter: James Taylor
> Assignee: Maryann Xue
> Priority: Major
> Attachments: PHOENIX-4585.patch
>
>
> Some remaining work from PHOENIX-3941: we currently do not capture the data
> plan as part of the index plan due to the way in which we rewrite the
> statement during join processing. See comment here for more detail:
> https://issues.apache.org/jira/browse/PHOENIX-3941?focusedCommentId=16351017&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-16351017
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
