[
https://issues.apache.org/jira/browse/CASSANDRA-9736?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16076117#comment-16076117
]
ZhaoYang commented on CASSANDRA-9736:
-------------------------------------
Semantic for {{alter view}} :
# support alter view
## if view is wildcard, eg. {{select *}}
### view cannot add column. all columns are selected
### view can drop column. eg. change from {{*}} to {{a,b}} but it may confuse
user later when adding new column to base and not included in view.
### view primary key cannot be rename, pls rename base table instead
## if view is not wildcard, eg. {{select a,b,c}}
### view can drop columns except for last remaining column
### view can add columns except for base's static column
## cannot drop restricted column(eg. {{where a=2}}) on view, because that
needs rebuild view data. dropping view and recreating view is better
## support altering view's {{table_options}}, eg. compaction, etc.
## view primary key cannot be altered
# support drop column from base if view doesn't select or restrict those columns
> Add alter statement for MV
> --------------------------
>
> Key: CASSANDRA-9736
> URL: https://issues.apache.org/jira/browse/CASSANDRA-9736
> Project: Cassandra
> Issue Type: Improvement
> Reporter: Carl Yeksigian
> Assignee: ZhaoYang
> Labels: materializedviews
> Fix For: 4.x
>
>
> {{ALTER MV}} would allow us to drop columns in the base table without first
> dropping the materialized views, since we'd be able to later drop columns in
> the MV.
> Also, we should be able to add new columns to the MV; a new builder would
> have to run to copy the values for these additional columns.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
