[FLINK-31291] Document table.exec.sink.upsert-materialize to none

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: table-store-0.4.0
• Component/s: Table Store
• Labels: pull-request-available
• Assignee: Guojun Li
• Reporter: Jingsong Lee
• Created: 02/Mar/23 04:03
• Updated: 03/Mar/23 07:11
• Resolved: 03/Mar/23 05:34

Description

The table store has the ability to correct disorder, such as:

https://nightlies.apache.org/flink/flink-table-store-docs-master/docs/concepts/primary-key-table/#sequence-field

But Flink SQL default sink materialize will result strange behavior, In particular, write to the agg table of the fts.

We should document this, set table.exec.sink.upsert-materialize to none always, set 'sequence.field' to table in case of disorder.

 

Issue Links

• links to: GitHub Pull Request #571
• links to: GitHub Pull Request #578