phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Maryann Xue (JIRA)" <>
Subject [jira] [Commented] (PHOENIX-4585) Prune local index regions used for join queries
Date Fri, 16 Feb 2018 18:45:00 GMT


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:
>             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:

This message was sent by Atlassian JIRA

View raw message