[
https://issues.apache.org/jira/browse/PHOENIX-5025?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16689988#comment-16689988
]
ASF GitHub Bot commented on PHOENIX-5025:
-----------------------------------------
GitHub user kadirozde opened a pull request:
https://github.com/apache/phoenix/pull/404
PHOENIX-5025 Tool to clean up orphan views
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/kadirozde/phoenix PHOENIX-5025
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/phoenix/pull/404.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #404
----
commit db753b99c6fdd065e36814e9eaadde2547b8451d
Author: Kadir <kozdemir@...>
Date: 2018-11-13T06:24:10Z
PHOENIX-5025 Tool to clean up orphan views
----
> Tool to clean up orphan views
> -----------------------------
>
> Key: PHOENIX-5025
> URL: https://issues.apache.org/jira/browse/PHOENIX-5025
> Project: Phoenix
> Issue Type: New Feature
> Reporter: Kadir OZDEMIR
> Assignee: Kadir OZDEMIR
> Priority: Major
>
> A view without its base table is an orphan view. Since views are virtual
> tables and their data is stored in their base tables, they are useless when
> they become orphan. A base table can have child views, grandchild views and
> so on. Due to some reasons/bugs, when a base table was dropped, its views
> were not not properly cleaned up in the past. For example, the drop table
> code did not support cleaning up grandchild views. This has been recently
> fixed by PHOENIX-4764. Although PHOENIX-4764 prevents new orphan views due to
> table drop operations, it does not clean up existing orphan views. It is also
> believed that when the system catalog table was split due to a bug in the
> past, it also contributed to creating orphan views as Phoenix did not support
> splittable system catalog. Therefore, Phoenix needs a tool to clean up orphan
> views.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
