raminqaf commented on code in PR #27901:
URL: https://github.com/apache/flink/pull/27901#discussion_r3063833073
##########
docs/content/docs/sql/reference/queries/changelog.md:
##########
@@ -75,26 +76,30 @@ The output columns are ordered as:
[partition_key_columns, remaining_columns_without_op]
```
-The op column is removed from the output. Output rows carry the appropriate
`RowKind` (INSERT, UPDATE_AFTER, or DELETE).
+The op column is removed from the output. Output rows carry the appropriate
change operation (INSERT, UPDATE_BEFORE, UPDATE_AFTER, or DELETE).
### Examples
#### Basic usage with standard op names
```sql
-- Input (append-only):
--- +I[id:1, op:'INSERT', name:'Alice']
--- +I[id:1, op:'UPDATE_AFTER', name:'Alice2']
--- +I[id:2, op:'DELETE', name:'Bob']
+-- +I[id:1, op:'INSERT', name:'Alice']
+-- +I[id:1, op:'UPDATE_BEFORE', name:'Alice']
+-- +I[id:1, op:'UPDATE_AFTER', name:'Alice2']
+-- +I[id:2, op:'DELETE', name:'Bob']
SELECT * FROM FROM_CHANGELOG(
input => TABLE cdc_stream PARTITION BY id
)
--- Output (upsert stream):
+-- Output (updating table):
-- +I[id:1, name:'Alice']
+-- -U[id:1, name:'Alice']
-- +U[id:1, name:'Alice2']
-- -D[id:2, name:'Bob']
+
+-- Table state after all events: {id:1, name:'Alice2'}
Review Comment:
Done
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
