[SPARK-41198] Streaming query metrics is broken with CTE

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.2.2, 3.3.1, 3.4.0
• Fix Version/s: 3.4.0
• Component/s: Structured Streaming
• Assignee: Jungtaek Lim
• Reporter: Jungtaek Lim
• Created: 18/Nov/22 19:03
• Updated: 20/Nov/22 21:44
• Resolved: 20/Nov/22 21:44

Description

We have observed a case the metrics are not available for the streaming query which contains CTE.

Looks like CTE was inlined in analysis phase in Spark 3.1.x and it was changed to be inlined in optimization phase in Spark 3.2.x. ProgressReporter depends on analyzed plan, hence the change made ProgressReporter to see CTE nodes, which ends up with having different number of leaf nodes between analyzed plan and executed plan.

Issue Links

• links to: [Github] Pull Request #38717 (HeartSaVioR)
• links to: [Github] Pull Request #38717 (HeartSaVioR)