swaroopak opened a new pull request #514: PHOENIX-5261: Implement ALTER TABLE/VIEW ADD COLUMN CASCADE URL: https://github.com/apache/phoenix/pull/514 This PR will allow an option to cascade the column to the corresponding indexes if it is added to the view or base table. (Below example is applicable for the table also) Let's suppose I have a base table A and a global view on it as A_GLOBAL_VIEW and 3 Global (currently, focusing on global indexes) indexes on the view A_GLOBAL_VIEW_INDEX_1, A_GLOBAL_VIEW_INDEX_2, and A_GLOBAL_VIEW_INDEX_3 The following syntax will add the new_column to the global view and also to all the 3 indexes on the view as an included column: ALTER VIEW A_GLOBAL_VIEW ADD new_column VARCHAR CASCADE INDEX ALL Let's say I want to add the column only to A_GLOBAL_VIEW_INDEX_2 and A_GLOBAL_VIEW_INDEX_3, the syntax will look like below: ALTER VIEW A_GLOBAL_VIEW ADD new_column VARCHAR CASCADE INDEX A_GLOBAL_VIEW_INDEX_2, A_GLOBAL_VIEW_INDEX_3
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
