[
https://issues.apache.org/jira/browse/PHOENIX-7458?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17897108#comment-17897108
]
Viraj Jasani commented on PHOENIX-7458:
---------------------------------------
Btw FYI, [~jisaac] has plans to make partial indexes work on SYSTEM.CATALOG.
Once we have it, i am planning to introduce new column in SYSTEM.CATALOG of
type BSON, so that going forward any new table attribute can be provided as
BsonDocument. This will eliminate new column creation for every new table
attribute that we introduce.
> Create new SYSTEM tables for tracking CDC Stream metadata
> ---------------------------------------------------------
>
> Key: PHOENIX-7458
> URL: https://issues.apache.org/jira/browse/PHOENIX-7458
> Project: Phoenix
> Issue Type: Sub-task
> Reporter: Palash Chauhan
> Assignee: Palash Chauhan
> Priority: Major
>
> # *SYSTEM.CDC_STREAM_STATUS :* Store the mapping from Table Name to a Stream
> Name (and its status). CDC can be disabled on a table and then enabled again
> - we will create a new Stream Name in that case. There can only be one Active
> stream per table - Stream Status can be part of the primary key for efficient
> lookup of the Stream Name, given a Table Name.
> ## TABLE_NAME : VARCHAR
> ## STREAM_STATUS : VARCHAR
> ## STREAM_NAME : VARCHAR
> ## _PK - (TABLE_NAME, STREAM_STATUS)_
> # *SYSTEM.CDC_STREAM :* Store metadata related to all open/closed partitions
> of a stream. Partitions represent hbase regions of the data table for which a
> CDC stream was enabled/created.
> ## TABLE_NAME : VARCHAR
> ## STREAM_NAME : VARCHAR
> ## PARTITION_ID : VARCHAR
> ## PARENT_PARTITION_ID : VARCHAR
> ## PARTITION_START_TIME : DATE/BIGINT
> ## PARTITION_END_TIME : DATE/BIGINT
> ## PARTITION_START_KEY : VARBINARY_ENCODED
> ## PARTITION_END_KEY : VARBINARY_ENCODED
> ## _PK - (TABLE_NAME, STREAM_NAME, PARTITION_ID)_
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
