You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "Viraj Jasani (Jira)" <ji...@apache.org> on 2023/07/31 06:24:00 UTC

[jira] [Created] (PHOENIX-7007) Configure maxLookbackAge for updatable views

Viraj Jasani created PHOENIX-7007:
-------------------------------------

             Summary: Configure maxLookbackAge for updatable views
                 Key: PHOENIX-7007
                 URL: https://issues.apache.org/jira/browse/PHOENIX-7007
             Project: Phoenix
          Issue Type: Improvement
            Reporter: Viraj Jasani


Phoenix max lookback age feature preserves live or deleted row versions that are only visible through the max lookback window, it does not preserve any unwanted row versions that should not be visible through the max lookback window. More details on the max lookback redesign: PHOENIX-6888

Similar to PHOENIX-7006, we should allow maxlookback to be configured for updatable views.

The purpose of this Jira is to allow maxlookback age as a view level property:
 * New column in SYSTEM.CATALOG to preserve updatable view level maxlookback age
 * PTable object to read the value of maxlookback from SYSTEM.CATALOG
 * Allow CREATE/ALTER VIEW DDLs to provide maxlookback attribute
 * CompactionScanner should use view level maxlookbackAge, if available, else use cluster level config

 

This can be achieved with similar strategy as redesign of TTL for views: PHOENIX-6978



--
This message was sent by Atlassian Jira
(v8.20.10#820010)