[PHOENIX-7232] Phoenix level compaction is not collecting delete markers beyond max lookback age for view indexes

• Type: Bug
• Status: In Progress
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: 5.3.0
• Assignee: Sanjeet Malhotra
• Reporter: Sanjeet Malhotra
• Created: 23/Feb/24 07:27
• Updated: 16/Apr/24 05:53

Description

Currently, with phoenix.table.ttl.enabled we try to retrieve PTable object using HBase table name and if PTable instance is null then skip the CompactionScanner completely. For view indexes, physical table name will be different from logical table name in SYSCAT as physical table name will have IDX prefix. For this case, we can get logical table name from physical table name by removing IDX prefix and then retrieving the PTable instance. 

 

Currently, delete markers are not getting collected for view indexes and cell count will keep increasing.