cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Merge error in streaming case

Remit
New Contributor III

I have a streaming case, where i stream from 2 sources: source1 and source2. I write to seperate streams to pick the data up from the landing area (step1). then i write 2 extra streams to apply some tranformations in order to give them the same schema and have the 2 streams write them to the same target (let's call it union_stream) (step 2). So far everything works fine. Then i write another stream to apply some tranformations to union_stream and write it to union_stream2 (step 3).  In this step all the data from source 1 flows perfectly through the stream but the data from source 2 doesn't. When i filter on source_name = source2, i get the error: Keeping the source of the MERGE statement materialized has failed repeatedly. Even when i execute step 3 without streaming i get the same error. I have also tried to not perform any transformations in step 3 and just do a MERGE into a table with the exact same schema, this led to the same error.

Any help would be appreciated. Thx in advance

1 ACCEPTED SOLUTION

Accepted Solutions

Remit
New Contributor III

Solved the problem by changing the cluster settings. The whole thing works when disabling Photon Acceleration...

View solution in original post

1 REPLY 1

Remit
New Contributor III

Solved the problem by changing the cluster settings. The whole thing works when disabling Photon Acceleration...

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group