Creating a persistent view that references both Unity Catalog and Hive Metastore objects is not supported in Unity Catalog
I tried to create a view in hive_metastore.default which would access a table from a different catalog. Is there any chance to do so?eg.create view myTest as select * from someCatalog.someSchema.someTable
- 9443 Views
- 5 replies
- 5 kudos
Latest Reply
Hi, so I don't know if you still have this problem (seeing as this post is almost 3 years old now haha) but I came across this when I was trying to solve an issue. What worked for me was creating the unity catalog table in the hive_metastore using an...
- 5 kudos