- 15068 Views
- 15 replies
- 22 kudos
How to resolve problem with upgrading external table to Unity Catalog?
I have a problem with upgrading table to Unity Catalog, I got the error:summary:Error in SQL statement:AnalysisException:org.apache.hadoop.hive.ql.metadata.HiveException:Unable to fetch table calexception. Exception thrown when executing query :SELEC...
- 15068 Views
- 15 replies
- 22 kudos
- 16444 Views
- 6 replies
- 4 kudos
No parent external location found for <S3-location> | External Table in UnityCatalog
Hi,We are trying to adopt the Unity Catalog and are testing out creating an External table with some data from the samples catalog that comes along with creating a meta store. The command we are using is:CREATE TABLE IF NOT EXISTS my_catalog.quicksta...
- 16444 Views
- 6 replies
- 4 kudos
- 4 kudos
In Unity catalog you have to pre-define the EXTERNAL LOCATION (and a STORAGE CREDENTIAL) before you use it this way. Please refer below:https://docs.databricks.com/data-governance/unity-catalog/manage-external-locations-and-credentials.html#manage-ex...
- 4 kudos