depth of view exceeds the maximum view resolution depth (100).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-19-2023 08:37 PM
I got this error after updating a view. How can I increase the value of spark.sql.view.maNestedViewDepth to work around this?
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-24-2023 12:12 AM
Hi, Could you please confirm if you are showing the view? (https://docs.databricks.com/sql/language-manual/sql-ref-syntax-aux-show-views.html) also, it will be helpful if you post the screenshot of the error.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-01-2023 04:54 AM
Thank you!
I found out the root cause for this error is that the view's new definition is trying to join another view which includes a join with this view itself, so it becomes an infinite loop.