[
https://issues.apache.org/jira/browse/PHOENIX-7013?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hari Krishna Dara reassigned PHOENIX-7013:
------------------------------------------
Assignee: Hari Krishna Dara
> CDC DQL Select query parser
> ---------------------------
>
> Key: PHOENIX-7013
> URL: https://issues.apache.org/jira/browse/PHOENIX-7013
> Project: Phoenix
> Issue Type: Sub-task
> Reporter: Viraj Jasani
> Assignee: Hari Krishna Dara
> Priority: Major
>
> The purpose of this sub-task is to provide DQL query capability for CDC
> (Change Data Capture) feature.
> The SELECT query parser can identify the given CDC table based on the table
> type defined in SYSTEM.CATALOG and it should be able to parse qualifiers (pre
> | post | latest | all) from the query.
> CDC DQL query sample:
>
> {code:java}
> Select * from <CDC Table Name> where PHOENIX_ROW_TIMESTAMP() >= TO_DATE( …)
> AND PHOENIX_ROW_TIMESTAMP() < TO_DATE( …)
> {code}
> This query would return the rows of the CDC table. The above select query can
> be hinted at by using a new CDC hint to return just the actual change, pre,
> post, or latest image of the row, or a combination of them.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
