[
https://issues.apache.org/jira/browse/FLINK-30341?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jingsong Lee updated FLINK-30341:
---------------------------------
Description:
In some scenarios, users need to get the changelog to do some auditing work,
such as determining the number of updates and inserts.
We can provide audit_log system table, users can get the rowkind information
column.
{code:java}
INSERT INTO T VALUES ('1', '2', '3');
INSERT INTO T VALUES ('1', '4', '5');
SELECT * FROM T$audit_log;
users can get:
- "+I", "1", "2", "3"
- "-U", "1", "2", "3";
- "+U", "1", "4", "5"
{code}
was:
In some scenarios, users need to get the changelog to do some auditing work,
such as determining the number of updates and inserts.
We can provide audit_log system table, users can get the rowkind information
column.
{code:java}
INSERT INTO %s VALUES ('1', '2', '3');
INSERT INTO %s VALUES ('1', '4', '5');
SELECT * FROM T$audit_log;
users can get:
- "+I", "1", "2", "3"
- "-U", "1", "2", "3";
- "+U", "1", "4", "5"
{code}
> Introduce audit_log system table
> --------------------------------
>
> Key: FLINK-30341
> URL: https://issues.apache.org/jira/browse/FLINK-30341
> Project: Flink
> Issue Type: New Feature
> Reporter: Jingsong Lee
> Assignee: Jingsong Lee
> Priority: Major
> Fix For: table-store-0.3.0
>
>
> In some scenarios, users need to get the changelog to do some auditing work,
> such as determining the number of updates and inserts.
> We can provide audit_log system table, users can get the rowkind information
> column.
> {code:java}
> INSERT INTO T VALUES ('1', '2', '3');
> INSERT INTO T VALUES ('1', '4', '5');
> SELECT * FROM T$audit_log;
> users can get:
> - "+I", "1", "2", "3"
> - "-U", "1", "2", "3";
> - "+U", "1", "4", "5"
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
