[
https://issues.apache.org/jira/browse/PHOENIX-7459?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Palash Chauhan reassigned PHOENIX-7459:
---------------------------------------
Assignee: Palash Chauhan
> Bootstrap stream metadata when CDC is enabled/created on a table
> ----------------------------------------------------------------
>
> Key: PHOENIX-7459
> URL: https://issues.apache.org/jira/browse/PHOENIX-7459
> Project: Phoenix
> Issue Type: Sub-task
> Reporter: Palash Chauhan
> Assignee: Palash Chauhan
> Priority: Major
>
> PHOENIX-7458 creates 2 new SYSTEM tables for tracking stream metadata. When
> CDC is enabled on a table using the CREATE CDC statement, populate the
> initial stream metadata into the two tables:
> # *SYSTEM.CDC_STREAM_STATUS*
> ## If a row already exists in this table for the given TableName and
> STREAM_STATUS = ACTIVE, fail the CREATE CDC operation since there can only be
> one active stream per table at any time.
> ## Otherwise, upsert (TABLE_NAME, ACTIVE, STREAM_NAME) where STREAM_NAME can
> be of the form stream-<tableName>-<createdTime>
> # *SYSTEM.CDC_STREAM*
> ## For all regions of the data table, upsert a row
> ### TABLE_NAME, STREAM_NAME
> ### PARTITION_ID is the encoded region name
> ### PARENT_PARTITION_ID is null
> ### PARTITION_START_TIME is the region id
> ### PARTITION_END_TIME is null
> ### PARTITION_START_KEY, PARTITION_END_KEY
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
