Palash Chauhan created PHOENIX-7459:
---------------------------------------
Summary: 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
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)
