Details
-
Sub-task
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
-
None
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:
Select * from <CDC Table Name> where PHOENIX_ROW_TIMESTAMP() >= TO_DATE( …) AND PHOENIX_ROW_TIMESTAMP() < TO_DATE( …)
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.