[
https://issues.apache.org/jira/browse/PHOENIX-7013?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Viraj Jasani updated PHOENIX-7013:
----------------------------------
Description:
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.
was:
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 Select query parser
> ---------------------------
>
> Key: PHOENIX-7013
> URL: https://issues.apache.org/jira/browse/PHOENIX-7013
> Project: Phoenix
> Issue Type: Sub-task
> Reporter: Viraj Jasani
> 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)
