[
https://issues.apache.org/jira/browse/PHOENIX-2968?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mujtaba Chohan updated PHOENIX-2968:
------------------------------------
Description:
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.
was:
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)
> 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
> 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)
