[jira] [Assigned] (PHOENIX-7008) CDC DDL Compiler

["Viraj Jasani (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-7008?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Viraj Jasani reassigned PHOENIX-7008:
-------------------------------------

    Assignee: Hari Krishna Dara

> CDC DDL Compiler
> ----------------
>
>                 Key: PHOENIX-7008
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-7008
>             Project: Phoenix
>          Issue Type: Sub-task
>            Reporter: Viraj Jasani
>            Assignee: Hari Krishna Dara
>            Priority: Major
>
> 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
>  
> ALTER and DROP CDC queries are provided by PHOENIX-7054.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)