[FLINK-29652] get duplicate result from sql-client in BATCH mode

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.13.0, 1.14.0, 1.15.0, 1.16.0
• Component/s: Table SQL / Client
• Labels: pull-request-available stale-assigned
• Assignee: Jingqi Shi
• Reporter: Jingqi Shi
• Created: 17/Oct/22 05:08
• Updated: 15/Aug/23 10:35

Description

In BATCH mode, we experienced problems with flink-sql-client when retrieving result record. We may get duplicate row records occasionally even if querying from a hive/hudi table which contains only one record.

 

For example, SELECT COUNT(1) AS val FROM x.test_hive_table, we may get:

+------+
| val  |
+------+
| 1    |
| …    |
| 1    |
+------+ 

 

Issue Links

• links to: GitHub Pull Request #21210