phoenix-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From GitBox <...@apache.org>
Subject [GitHub] [phoenix] swaroopak opened a new pull request #514: PHOENIX-5261: Implement ALTER TABLE/VIEW ADD COLUMN CASCADE
Date Wed, 05 Jun 2019 22:23:15 GMT
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:
users@infra.apache.org


With regards,
Apache Git Services

Mime
View raw message