[ 
https://issues.apache.org/jira/browse/PHOENIX-4764?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16624252#comment-16624252
 ] 

Bin Shi commented on PHOENIX-4764:
----------------------------------

Regarding "If we try to recreate a base table that was previously dropped but 
whose child view metadata wasn't cleaned up throw an exception" and "If we try 
to recreate a table that was previously dropped we then try to drop the child 
views", when we "recreate" a table that was previously dropped, is it feasible 
to treat the new created table to be a different table to the table that was 
previously dropped in HBase/Phoenix, even they have the same namespace and 
table name? The new table can have a unique internal identifier to 
differentiate from the table that was previously dropped. The benefit of doing 
this is that, once a table is dropped, cleaning up its orphan child views and 
recreating a new table with the same name are totally independent which results 
in simplicity and less chance for throwing errors.

> Cleanup metadata of child views for a base table that has been dropped
> ----------------------------------------------------------------------
>
>                 Key: PHOENIX-4764
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-4764
>             Project: Phoenix
>          Issue Type: Sub-task
>            Reporter: Thomas D'Silva
>            Assignee: Kadir OZDEMIR
>            Priority: Major
>
> When we drop a base table, we no longer drop all the child view metadata. 
> Clean up the child view metadata during compaction. 
> If we try to recreate a base table that was previously dropped but whose 
> child view metadata wasn't cleaned up throw an exception. Add a test for 
> this. 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to