[
https://issues.apache.org/jira/browse/PHOENIX-5025?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16719742#comment-16719742
]
ASF GitHub Bot commented on PHOENIX-5025:
-----------------------------------------
GitHub user kadirozde opened a pull request:
https://github.com/apache/phoenix/pull/413
PHOENIX-5025 Tool to clean up orphan views (addendum)
This patch removes Java 8 specific APIs and sets the SCN on the connection
that identifies orphan views and links, based on the given or default age
argument.
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/413.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 #413
----
commit 7cbb72f8c23f3e53839fc55b0f610f4d99acc7a6
Author: Kadir <kozdemir@...>
Date: 2018-12-13T01:53:38Z
PHOENIX-5025 Tool to clean up orphan views (addendum)
----
> 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
> Fix For: 5.0.0
>
> Attachments: PHOENIX-5025.master.0001.patch, PHOENIX-5025.master.patch
>
>
> 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)
