[ https://issues.apache.org/jira/browse/PHOENIX-7671?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Viraj Jasani updated PHOENIX-7671: ---------------------------------- Description: TTL of the CDC index is same as the maxLookback configured at the cluster level. If the data table has different value of maxLookback than cluster level, the table level maxLookback is not used as TTL by the cdc index of the same data table. The purpose of this Jira is to sync the value of maxLookback from data table to index table's TableDescriptor while creating the index. Similarly, when the maxLookback value of the data table is altered using ALTER TABLE DDL, same value should be applied to all indexes. The major compaction of CDC index should therefore consider data table's maxLookback value (from data table's descriptor) as it's TTL value. was: TTL of the CDC index is same as the maxLookback configured at the cluster level. If the data table has different value of maxLookback than cluster level, the table level maxLookback is not used as TTL by the cdc index of the same data table. The purpose of this Jira is to provide sync the value of maxLookback from data table to index table's TableDescriptor while creating the index. The major compaction of CDC index should therefore consider data table's maxLookback value (from data table's descriptor) as it's TTL value. > Sync maxLookback from data table to indexes > ------------------------------------------- > > Key: PHOENIX-7671 > URL: https://issues.apache.org/jira/browse/PHOENIX-7671 > Project: Phoenix > Issue Type: Improvement > Reporter: Viraj Jasani > Assignee: Viraj Jasani > Priority: Major > > TTL of the CDC index is same as the maxLookback configured at the cluster > level. If the data table has different value of maxLookback than cluster > level, the table level maxLookback is not used as TTL by the cdc index of the > same data table. > The purpose of this Jira is to sync the value of maxLookback from data table > to index table's TableDescriptor while creating the index. Similarly, when > the maxLookback value of the data table is altered using ALTER TABLE DDL, > same value should be applied to all indexes. > The major compaction of CDC index should therefore consider data table's > maxLookback value (from data table's descriptor) as it's TTL value. -- This message was sent by Atlassian Jira (v8.20.10#820010)