[jira] [Created] (PHOENIX-2968) Reduce alter statement RPC when table/view is set with APPEND_ONLY_SCHEMA and high value for UPDATE_CACHE_FREQUENCY

["Mujtaba Chohan (JIRA)" <ji...@apache.org>]

Mujtaba Chohan created PHOENIX-2968:
---------------------------------------

             Summary: Reduce alter statement RPC when table/view is set with APPEND_ONLY_SCHEMA and high value for UPDATE_CACHE_FREQUENCY
                 Key: PHOENIX-2968
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2968
             Project: Phoenix
          Issue Type: Bug
            Reporter: Mujtaba Chohan
            Assignee: James Taylor


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 message was sent by Atlassian JIRA
(v6.3.4#6332)