[jira] [Resolved] (PHOENIX-6645) Remove unneccessary SCN related properties from SYSTEM tables on upgrade

["Istvan Toth (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-6645?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Istvan Toth resolved PHOENIX-6645.
----------------------------------
    Resolution: Fixed

Committed to all active branches.

> 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
>             Fix For: 4.17.0, 5.2.0, 4.16.2, 5.1.3
>
>
> 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)