[
https://issues.apache.org/jira/browse/PHOENIX-2999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15356667#comment-15356667
]
James Taylor edited comment on PHOENIX-2999 at 6/30/16 7:31 AM:
----------------------------------------------------------------
Also, please file another JIRA to set the TABLE_TYPE on the link row so we
don't need to join back to the SYSTEM.CATALOG table to get it. The query to
find child views is already a bit of a bottleneck, so the join won't help. You
could even make that change now if you want since all local indexes are getting
created again for 4.8, so it'd be set when the upgrade happens. Then you could
just have another filter. Keep in mind that if you only set it for local
indexes, you'd want the filter to pass if the attribute is not present.
was (Author: jamestaylor):
Also, please file another JIRA to set the TABLE_TYPE on the link row so we
don't need to join back to the SYSTEM.CATALOG table to get it. You could even
make that change now if you want since all local indexes are getting created
again for 4.8, so it'd be set when the upgrade happens. Then you could just
have another filter. Keep in mind that if you only set it for local indexes,
you'd want the filter to pass if the attribute is not present.
> Upgrading Multi-tenant table to map with namespace using upgradeUtil
> --------------------------------------------------------------------
>
> Key: PHOENIX-2999
> URL: https://issues.apache.org/jira/browse/PHOENIX-2999
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.8.0
> Reporter: Ankit Singhal
> Assignee: Ankit Singhal
> Priority: Critical
> Fix For: 4.8.0
>
> Attachments: PHOENIX-2999.patch, PHOENIX-2999_v1.patch,
> PHOENIX-2999_v2.patch, PHOENIX-2999_v3.patch
>
>
> currently upgradeUtil doesn't handle multi-tenant table with tenant views
> properly.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
