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

Viraj Jasani updated PHOENIX-7795:
----------------------------------
    Fix Version/s: 5.3.2
                       (was: 5.3.1)

> Tenant TTL
> ----------
>
>                 Key: PHOENIX-7795
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-7795
>             Project: Phoenix
>          Issue Type: Improvement
>            Reporter: Palash Chauhan
>            Assignee: Palash Chauhan
>            Priority: Major
>             Fix For: 5.4.0, 5.3.2
>
>
> Applications running on multi-tenant Phoenix tables often need different data 
> retention policies per tenant. For example, Tenant A may require 30-day 
> retention while Tenant B requires 90-day retention. Today, per-tenant TTL can 
> be achieved using Conditional TTL PHOENIX-7170 but it would require 
> enumerating all tenants and their TTL values in the TTL Expression and for a 
> large number of tenants, this expression would be very hard to maintain. 
> This JIRA instead aims to leverage existing View TTL implementation to enable 
> Tenant TTL. This approach would require creating global views on a multi 
> tenant table with where clause on the tenant_id column. 
> Read masking should work but CompactionScanner might need changes 
> 1) to handle the Row Key Matcher created by such views 
> 2) trie pruning to reduce the memory taken up by GLOBAL_VIEWS trie since all 
> global views are loaded upfront and one view per tenant could mean a large 
> number of global views
> More details in 
> [document|https://docs.google.com/document/d/1A3TikNN_XwV6pQBqgpb6U0pj_LtBWf_1Q-Cdc_P0Bmo/edit?tab=t.0].



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

Reply via email to