[FLINK-22897] FlinkSQL1.12 Sink to Hive with diffrent parallelism will due to produce many small files

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.12.1
• Fix Version/s: 1.20.0
• Component/s: Table SQL / Ecosystem
• Labels: auto-deprioritized-critical pull-request-available
• Assignee: Unassigned
• Reporter: zhengjiewen
• Created: 07/Jun/21 07:23
• Updated: 11/Mar/24 12:44

Description

I try to use flink sql in batch mode, to sink data into hive partition table, here is the sql:

 

//代码占位符
INSERT OVERWRTITE 【targetTable】SELECT 【field】FROM 【sourceTable】;

 

 

 

And I found that when the parallelism of the sink operator is different from that of the operator before it, a large number of small files will be generated. But this is not the case when the parallelism is the same.

Issue Links

• links to: GitHub Pull Request #16311