[ https://issues.apache.org/jira/browse/PHOENIX-2968?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thomas D'Silva updated PHOENIX-2968: ------------------------------------ Fix Version/s: (was: 4.9.0) 4.8.0 > Minimize RPCs for ALTER statement over APPEND_ONLY_SCHEMA > --------------------------------------------------------- > > Key: PHOENIX-2968 > URL: https://issues.apache.org/jira/browse/PHOENIX-2968 > Project: Phoenix > Issue Type: Bug > Reporter: Mujtaba Chohan > Assignee: Thomas D'Silva > Labels: Argus > Fix For: 4.8.0 > > Attachments: PHOENIX-2968.patch > > > View is created with {{CREATE VIEW IF NOT EXISTS ... APPEND_ONLY_SCHEMA = > true, UPDATE_CACHE_FREQUENCY=900000}} > If {{ALTER VIEW <VIEW_NAME> ADD IF NOT EXISTS MYCOL VARCHAR}} is executed > before each upsert statement then performance for each 1K batch upsert > degrades by ~40X (50ms for 1K batch without alter statement vs 2300ms with > alter statement) > This is for the case when MYCOL exists. -- This message was sent by Atlassian JIRA (v6.3.4#6332)