[
https://issues.apache.org/jira/browse/PHOENIX-6645?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Istvan Toth updated PHOENIX-6645:
---------------------------------
Description:
Before PHOENIX-4575, we used to create all SYSTEM tables with the
KEEP_DELETED_CELLS and VERSIONS attribute set.
PHOENIX-4575 removes this flags from tables where it doesn't make sense,
SYSTEM.STATS and SYSTEM.LOG, but this is not done automatically when upgrading.
Having KEEP_DELETED_CELLS and VERSIONS set on SYSTEM.STATS is a major
performance problem, so we should fix the table properties on upgrade.
was:
Before PHOENIX-4575, we used to create all SYSTEM tables with the
KEEP_DELETED_CELLS and VERSIONS attribute set.
PHOENIX-4575 removes this flags from tables where it doesn't make sense,
especially SYSTEM.STATS, but this is not done automatically when upgrading.
Having KEEP_DELETED_CELLS set on SYSTEM.STATS is a major performance problem,
so we should fix the table properties on upgrade.
> Remove unneccessary SCN related properties from SYSTEM tables on upgrade
> ------------------------------------------------------------------------
>
> Key: PHOENIX-6645
> URL: https://issues.apache.org/jira/browse/PHOENIX-6645
> Project: Phoenix
> Issue Type: Bug
> Components: core
> Affects Versions: 5.2.0
> Reporter: Istvan Toth
> Assignee: Istvan Toth
> Priority: Minor
>
> Before PHOENIX-4575, we used to create all SYSTEM tables with the
> KEEP_DELETED_CELLS and VERSIONS attribute set.
> PHOENIX-4575 removes this flags from tables where it doesn't make sense,
> SYSTEM.STATS and SYSTEM.LOG, but this is not done automatically when
> upgrading.
> Having KEEP_DELETED_CELLS and VERSIONS set on SYSTEM.STATS is a major
> performance problem, so we should fix the table properties on upgrade.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
