[
https://issues.apache.org/jira/browse/FLINK-40497?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gustavo de Morais reassigned FLINK-40497:
-----------------------------------------
Assignee: Gustavo de Morais
> Allow materialized tables to default to ON CONFLICT DO ERROR
> ------------------------------------------------------------
>
> Key: FLINK-40497
> URL: https://issues.apache.org/jira/browse/FLINK-40497
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / API
> Reporter: Gustavo de Morais
> Assignee: Gustavo de Morais
> Priority: Major
>
> A materialized table whose declared primary key differs from the query's
> upsert key currently falls back to an implicit {{{}ON CONFLICT DO
> DEDUPLICATE{}}}, which needs a state-heavy deduplicating materializer.
> Add an opt-in config option so a materialized table can default to {{ON
> CONFLICT DO ERROR}} instead, avoiding that materializer — but only when every
> source in the query already declares a watermark, since {{ON CONFLICT DO
> ERROR}} requires one. When a watermark is missing on any source, keep the
> existing {{DEDUPLICATE}} default so table creation never fails because of
> this option.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
