You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Palash Chauhan (Jira)" <ji...@apache.org> on 2025/01/03 03:21:00 UTC
[jira] [Resolved] (PHOENIX-7459) Bootstrap stream metadata when CDC is enabled/created on a table
[ https://issues.apache.org/jira/browse/PHOENIX-7459?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Palash Chauhan resolved PHOENIX-7459.
-------------------------------------
Fix Version/s: 5.3.0
Resolution: Fixed
> 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
> Fix For: 5.3.0
>
>
> 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)