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)