Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-07-2022 08:03 AM
Thanks @Hubert Dudek so I can try to set this failing tables to serializable by default, just in case, I understand by the history that this is what is currently using, but can't hurt
As seen here: https://docs.databricks.com/delta/optimizations/isolation-level.html
ALTER TABLE <table-name> SET TBLPROPERTIES ('delta.isolationLevel' = 'Serializable')
And for the commit service I never have more than 1 cluster writing to those tables and for reasuring I have this Spark setting on the jobs:
.config("spark.databricks.delta.multiClusterWrites.enabled", "false")
BTW, I never seen any serializable error on jobs, do they show on DESCRIBE HISTORY?
thanks!