Viraj Jasani created PHOENIX-7008:
-------------------------------------
Summary: CDC DDL Compiler
Key: PHOENIX-7008
URL: https://issues.apache.org/jira/browse/PHOENIX-7008
Project: Phoenix
Issue Type: Sub-task
Reporter: Viraj Jasani
The purpose of this sub-task is to provide DDL query capability for CDC (Change
Data Capture) feature.
The CREATE CDC table query can look something like:
{code:java}
Create CDC <CDC Table Name> on <Data Table Name> (PHOENIX_ROW_TIMESTAMP() |
<Data Table Column>) INCLUDE (pre | post | latest | all) TTL = <Age in seconds>
INDEX = <GLOBAL | LOCAL> SALT_BUCKETS=<salt bucket count> {code}
The changes include:
* Create new table type CDC in SYSTEM.CATALOG
* Provide CDC table to data table link in SYSTEM.CATALOG
* Query parser/grammer changes
* PTable link type: CDC_TABLE (from CDC table to data table)
* MetaDataClient and ConnectionQueryServicesImpl (CQSI) changes to ensure no
physical table gets created for CDC, it is rather treated as virtual table
* Create Uncovered global index on data table using either
PHOENIX_ROW_TIMESTAMP() or a data table column (as provided in the query)
* Store INCLUDE image values (pre/post/latest/all) as CDC virtual table
property in SYSTEM.CATALOG
* ALTER CDC query should be able to update any CDC attributes
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
