- 11660 Views
- 7 replies
- 4 kudos
no information on character_maximum_length and is_identity in unity catalog table system.information_schema.columns
no information on character_maximum_length and is_identity in unity catalog table system.information_schema.columnstable definition exampleCREATE TABLE tyable_name ( UniqueID bigint not null GENERATED ALWAYS AS IDENTITY , ID varchar(256))looks like ...
- 11660 Views
- 7 replies
- 4 kudos
- 4 kudos
Hello Team,Still i am facing same issue of value zero in character_maximum_length. Is there any other way we can get character_maximum_length of columns?When we can expect to resolve this bug?
- 4 kudos
- 4898 Views
- 3 replies
- 1 kudos
- 4898 Views
- 3 replies
- 1 kudos
- 1 kudos
Starting DBR 12.1 you can run the UNDROP command to undrop a managed or external table. The table must be in Unity Catalog for this feature to work. See https://docs.databricks.com/sql/language-manual/sql-ref-syntax-ddl-undrop-table.html for more det...
- 1 kudos
- 2109 Views
- 2 replies
- 0 kudos
How to update change data UnityCatalog table after migrating hive metastore delta table
If I will migrate the Hive_metastore table into Unity Catalog table and subsequently hive metastore table is target of curation process. how I will migrate the delta record from Hive_metastore table to Unity Catalog table
- 2109 Views
- 2 replies
- 0 kudos
- 0 kudos
Hi @Vivek Singh Banafar​ Hope everything is going great.Just checking in. Does @Debayan Mukherjee​'s response answer your question? If yes, would you be happy to mark it as best so that other members can find the solution more quickly?We'd love to he...
- 0 kudos
- 7149 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"...
- 7149 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
- 6049 Views
- 3 replies
- 1 kudos
Resolved! Table ACLs, secrets, and compute clusters
I am adding a credential to access MongoDB through the Python MongoDB Spark connector. It is stored as a secret and the `users` group has `MANAGE` ACL privileges. I turned on table ACLs and created a `High Concurrency` compute cluster. I then run a s...
- 6049 Views
- 3 replies
- 1 kudos
- 1 kudos
@Erik Louie​ looks the issue is resolved. Please let me know if you need further help on this. Thanks!
- 1 kudos