[jira] [Commented] (PHOENIX-2156) Support drop of column from table with views

["James Taylor (JIRA)" <ji...@apache.org>]

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

James Taylor commented on PHOENIX-2156:
---------------------------------------

I think supporting this would be pretty trivial and it's strange that you can add columns to a base table but not remove them. IMHO, we should target this for the next release to round out this functionality.

> Support drop of column from table with views
> --------------------------------------------
>
>                 Key: PHOENIX-2156
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2156
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: James Taylor
>            Assignee: Thomas D'Silva
>             Fix For: 4.8.0
>
>
> Much like PHOENIX-1504 allows a column to be added to a base view, we should support dropping a column from a table that has views as well. These seems like a simpler problem: you just need to query for all views with a BASE_COLUMN_COUNT < dropped_column_ordinal_pos, decrement the ordinal positions of columns after that, and drop indexes that reference the column being dropped.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)