[SPARK-29568] Add flag to stop existing stream when new copy starts

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: Structured Streaming
• Assignee: Burak Yavuz
• Reporter: Burak Yavuz
• Created: 23/Oct/19 09:47
• Updated: 03/Jan/20 01:42
• Resolved: 03/Jan/20 01:42

Description

In multi-tenant environments where you have multiple SparkSessions, you can accidentally start multiple copies of the same stream (i.e. streams using the same checkpoint location). This will cause all new instantiations of the new stream to fail. However, sometimes you may want to turn off the old stream, as the old stream may have turned into a zombie (you no longer have access to the query handle or SparkSession).

It would be nice to have a SQL flag that allows the stopping of the old stream for such zombie cases.

Issue Links

• links to: GitHub Pull Request #26225