Palash Chauhan created PHOENIX-7795:
---------------------------------------
Summary: 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
Fix For: 5.4.0, 5.3.1
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
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
