- 10052 Views
- 5 replies
- 5 kudos
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
- 10052 Views
- 5 replies
- 5 kudos
- 5 kudos
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
- 5382 Views
- 2 replies
- 1 kudos
Resolved! Is it possible to manage access for legacy catalogs (hive_metastore) in Terraform?
We have been successfully managing access for our unity catalogs using the databricks_grant resources in Terraform. Now we want to enable the Rudderstack integration for Databricks, but that does not support unity catalog and instead put files inside...
- 5382 Views
- 2 replies
- 1 kudos
- 1 kudos
@Mattias P​ :Unfortunately, it is not currently possible to manage access to the Hive Metastore catalog (or other external metastores) using the databricks_grant resource in Terraform. This is because the databricks_grant resource is specifically des...
- 1 kudos
- 6287 Views
- 7 replies
- 5 kudos
READ FILES and WRITE FILES when using Hive Metastore
Hello,I'm confused about documentation on privilege types when using HMS.The following page is supposed to talk about HMShttps://docs.databricks.com/sql/language-manual/sql-ref-privileges-hms.htmlbut it also mentions READ FILESQuery files directly us...
- 6287 Views
- 7 replies
- 5 kudos
- 5 kudos
Hi @Chris Nawara​ I'm sorry you could not find a solution to your problem in the answers provided.Our community strives to provide helpful and accurate information, but sometimes an immediate solution may only be available for some issues.I suggest ...
- 5 kudos
- 1787 Views
- 0 replies
- 2 kudos
AWS VPC service endpoint for internal RDS Hive metastore
We are setting up Databricks on our AWS account using customer managed VPC and enabling private link. I could see the private endpoints for frontend and backend with which we could spin up our EC2 instances. But the problem we are facing is to connec...
- 1787 Views
- 0 replies
- 2 kudos
- 6780 Views
- 4 replies
- 6 kudos
Resolved! Cannot create a table having a column whose name contains commas in Hive metastore.
Hi Tried to create a delta table from spark data frame using below command:destination_path = "/dbfs/mnt/kidneycaredevstore/delta/df_corr_feats_spark_4"df_corr_feats_spark.write.format("delta").option("delta.columnMapping.mode", "name").option("path"...
- 6780 Views
- 4 replies
- 6 kudos
- 6 kudos
Hi @Shafiul Alam​ ,who gave those names to columns? you can rename you columns, replace spaces / special characters, for example:%python import re list_of_columns = df_corr_feats_spark.colums renamed_list_of_columns = [ re.sub(r'[^0-9a-zA-Z]+', "_", ...
- 6 kudos
- 7756 Views
- 3 replies
- 1 kudos
Exploiting Hive Metastore of Databricks for lineage
Hi allWanted to check if anyone has made an attempt to exploit the Hive Metastore of Databricks for lineage?For example, I loaded metadata of 2 databricks databases using the Collibra Marketplace provided Databricks driver. Here is the scenario -Data...
- 7756 Views
- 3 replies
- 1 kudos
- 1 kudos
@Chetan Kardekar​ @Kaniz Fatma​ yes, I still need a standard way (through SQL) to access Hive Metastore.
- 1 kudos