[
https://issues.apache.org/jira/browse/FLINK-24547?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17429200#comment-17429200
]
Jark Wu commented on FLINK-24547:
---------------------------------
Actually, I have some concerns about this feature, because users may
encountered other problems when using it.
For example:
{code}
SELECT id, count(*), sum(price) FROM
(
SELECT * FROM mysql-cdc WHERE ROW_KIND() <> '-U'
)
GROUP BY id
{code}
It's hard to explain the semantic and the result of this SQL query.
What do you think [~twalthr].
> A function named row_kind() can get row_kind
> --------------------------------------------
>
> Key: FLINK-24547
> URL: https://issues.apache.org/jira/browse/FLINK-24547
> Project: Flink
> Issue Type: New Feature
> Components: Table SQL / Planner
> Reporter: jocean.shi
> Priority: Not a Priority
> Labels: pull-request-available
> Fix For: 1.15.0
>
>
> Add a function can get row_kind. In many case we need cdc data rowKind, such
> as agg rowKind or filter some rowKind data, the function return
> "+I","-U","+U","-D",
> you can use this function as "select row_kind() as op from xxx".
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
