AWS Glue database JDBC writes PARTIAL data.. how to avoid that ?

0

How to make sure a particular dynamic frame is not committed partially to MySQL database ? Is there an option in write_from_catalog to achieve that ?

已提問 9 個月前檢視次數 204 次
1 個回答
0

Not really, you would need a distributed transactions coordination between nodes that neither Glue nor Spark support.
What you can do is instead of writing to the final table, write to a temporary table and once the write operation is complete issue a DB command (using JDBC or other library) to do the merge inside the DB in a transactional way.

profile pictureAWS
專家
已回答 9 個月前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南