[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)]

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)