[ https://issues.apache.org/jira/browse/PHOENIX-2968?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
James Taylor updated PHOENIX-2968: ---------------------------------- Summary: Minimize RPCs for ALTER statement over APPEND_ONLY_SCHEMA (was: Reduce alter statement RPC when table/view is set with APPEND_ONLY_SCHEMA and high value for UPDATE_CACHE_FREQUENCY) > 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: James Taylor > Labels: Argus > > 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)